delete from bss_Member
delete from bss_MemberIdCards

select * from bss_member where firstname = 'DAVID' and lastname = 'ALLGAIER'
select * from bss_memberidcards where MemberID = (select memberid from bss_member where firstname = 'DAVID' and lastname = 'ALLGAIER')


if not exists (select * from bss_member where firstname = 'DAVID' and lastname = 'ALLGAIER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DAVID', 'ALLGAIER', 'DALLGAIER', 'password')
end


if not exists (select * from bss_member where firstname = 'DAVID' and lastname = 'ALLGAIER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DAVID', 'ALLGAIER', 'DALLGAIER', 'password')
end


if not exists (select * from bss_member where firstname = 'RON' and lastname = 'ARDIZONI') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('RON', 'ARDIZONI', 'RARDIZONI', 'password')
end


if not exists (select * from bss_member where firstname = 'LARS' and lastname = 'ARIENTI') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('LARS', 'ARIENTI', 'LARIENTI', 'password')
end


if not exists (select * from bss_member where firstname = 'CALLIE' and lastname = 'ATWELL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CALLIE', 'ATWELL', 'CATWELL', 'password')
end


if not exists (select * from bss_member where firstname = 'SANDRA' and lastname = 'AULD') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('SANDRA', 'AULD', 'SAULD', 'password')
end


if not exists (select * from bss_member where firstname = 'JOE' and lastname = 'BAILEY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JOE', 'BAILEY', 'JBAILEY', 'password')
end


if not exists (select * from bss_member where firstname = 'VALERIE' and lastname = 'BAILEY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('VALERIE', 'BAILEY', 'VBAILEY', 'password')
end


if not exists (select * from bss_member where firstname = 'JASON' and lastname = 'BAKER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JASON', 'BAKER', 'JBAKER', 'password')
end


if not exists (select * from bss_member where firstname = 'JESSE' and lastname = 'BARAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JESSE', 'BARAN', 'JBARAN', 'password')
end


if not exists (select * from bss_member where firstname = 'JP' and lastname = 'BARBEAU') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JP', 'BARBEAU', 'JBARBEAU', 'password')
end


if not exists (select * from bss_member where firstname = 'JAY' and lastname = 'BARRANGER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JAY', 'BARRANGER', 'JBARRANGER', 'password')
end


if not exists (select * from bss_member where firstname = 'THERESA' and lastname = 'BARRON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('THERESA', 'BARRON', 'TBARRON', 'password')
end


if not exists (select * from bss_member where firstname = 'JOHN' and lastname = 'BARROWS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JOHN', 'BARROWS', 'JBARROWS', 'password')
end


if not exists (select * from bss_member where firstname = 'JOANN' and lastname = 'BELL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JOANN', 'BELL', 'JBELL', 'password')
end


if not exists (select * from bss_member where firstname = 'JOANNA' and lastname = 'BELL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JOANNA', 'BELL', 'JBELL', 'password')
end


if not exists (select * from bss_member where firstname = 'MICHAEL' and lastname = 'BELLETZKE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MICHAEL', 'BELLETZKE', 'MBELLETZKE', 'password')
end


if not exists (select * from bss_member where firstname = 'BEN' and lastname = 'BERGMAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('BEN', 'BERGMAN', 'BBERGMAN', 'password')
end


if not exists (select * from bss_member where firstname = 'DAVID' and lastname = 'BJORKLUND') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DAVID', 'BJORKLUND', 'DBJORKLUND', 'password')
end


if not exists (select * from bss_member where firstname = 'LORI' and lastname = 'BLACK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('LORI', 'BLACK', 'LBLACK', 'password')
end


if not exists (select * from bss_member where firstname = 'LORI' and lastname = 'BLACK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('LORI', 'BLACK', 'LBLACK', 'password')
end


if not exists (select * from bss_member where firstname = 'JUSTIN' and lastname = 'BONA') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JUSTIN', 'BONA', 'JBONA', 'password')
end


if not exists (select * from bss_member where firstname = 'MONTGOMERY' and lastname = 'BOPP') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MONTGOMERY', 'BOPP', 'MBOPP', 'password')
end


if not exists (select * from bss_member where firstname = 'JAKE' and lastname = 'BORDEN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JAKE', 'BORDEN', 'JBORDEN', 'password')
end


if not exists (select * from bss_member where firstname = 'ELISSA' and lastname = 'BOSWORTH') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ELISSA', 'BOSWORTH', 'EBOSWORTH', 'password')
end


if not exists (select * from bss_member where firstname = 'EVELYN' and lastname = 'BOUCHARD') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('EVELYN', 'BOUCHARD', 'EBOUCHARD', 'password')
end


if not exists (select * from bss_member where firstname = 'ROBERT' and lastname = 'BRADSHAW') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ROBERT', 'BRADSHAW', 'RBRADSHAW', 'password')
end


if not exists (select * from bss_member where firstname = 'TERRI' and lastname = 'BRENNAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('TERRI', 'BRENNAN', 'TBRENNAN', 'password')
end


if not exists (select * from bss_member where firstname = 'SARAH' and lastname = 'BRICE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('SARAH', 'BRICE', 'SBRICE', 'password')
end


if not exists (select * from bss_member where firstname = 'ALEX' and lastname = 'BRINK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ALEX', 'BRINK', 'ABRINK', 'password')
end


if not exists (select * from bss_member where firstname = 'KATIE' and lastname = 'BROWER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('KATIE', 'BROWER', 'KBROWER', 'password')
end


if not exists (select * from bss_member where firstname = 'ALEX' and lastname = 'BROWN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ALEX', 'BROWN', 'ABROWN', 'password')
end


if not exists (select * from bss_member where firstname = 'HENRY' and lastname = 'BROWN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('HENRY', 'BROWN', 'HBROWN', 'password')
end


if not exists (select * from bss_member where firstname = 'LEAH' and lastname = 'BRUSH') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('LEAH', 'BRUSH', 'LBRUSH', 'password')
end


if not exists (select * from bss_member where firstname = 'LISA' and lastname = 'BURKLUND') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('LISA', 'BURKLUND', 'LBURKLUND', 'password')
end


if not exists (select * from bss_member where firstname = 'ROB' and lastname = 'BURNELL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ROB', 'BURNELL', 'RBURNELL', 'password')
end


if not exists (select * from bss_member where firstname = 'SOPHIA' and lastname = 'BURNELL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('SOPHIA', 'BURNELL', 'SBURNELL', 'password')
end


if not exists (select * from bss_member where firstname = 'PATRICK' and lastname = 'BURNS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('PATRICK', 'BURNS', 'PBURNS', 'password')
end


if not exists (select * from bss_member where firstname = 'CHARLIE' and lastname = 'BUXTON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CHARLIE', 'BUXTON', 'CBUXTON', 'password')
end


if not exists (select * from bss_member where firstname = 'GREG' and lastname = 'CARLSON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GREG', 'CARLSON', 'GCARLSON', 'password')
end


if not exists (select * from bss_member where firstname = 'CHRISTOPE' and lastname = 'CARNESE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CHRISTOPE', 'CARNESE', 'CCARNESE', 'password')
end


if not exists (select * from bss_member where firstname = 'CHRISTOPE' and lastname = 'CARNESE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CHRISTOPE', 'CARNESE', 'CCARNESE', 'password')
end


if not exists (select * from bss_member where firstname = 'TYLER' and lastname = 'CARNESE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('TYLER', 'CARNESE', 'TCARNESE', 'password')
end


if not exists (select * from bss_member where firstname = 'MARYA' and lastname = 'CASARTELLO') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MARYA', 'CASARTELLO', 'MCASARTELLO', 'password')
end


if not exists (select * from bss_member where firstname = 'NIAMH' and lastname = 'CHAMPINY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('NIAMH', 'CHAMPINY', 'NCHAMPINY', 'password')
end


if not exists (select * from bss_member where firstname = 'ADAM' and lastname = 'CHARBONNEAU') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ADAM', 'CHARBONNEAU', 'ACHARBONNEAU', 'password')
end


if not exists (select * from bss_member where firstname = 'ADAM' and lastname = 'CHARBONNEAU') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ADAM', 'CHARBONNEAU', 'ACHARBONNEAU', 'password')
end


if not exists (select * from bss_member where firstname = 'COLE' and lastname = 'CHRISTINA') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('COLE', 'CHRISTINA', 'CCHRISTINA', 'password')
end


if not exists (select * from bss_member where firstname = 'MELANIE' and lastname = 'CIENCIWA') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MELANIE', 'CIENCIWA', 'MCIENCIWA', 'password')
end


if not exists (select * from bss_member where firstname = 'JAMES' and lastname = 'CLARK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JAMES', 'CLARK', 'JCLARK', 'password')
end


if not exists (select * from bss_member where firstname = 'WILLIAM' and lastname = 'CLARK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('WILLIAM', 'CLARK', 'WCLARK', 'password')
end


if not exists (select * from bss_member where firstname = 'MARK' and lastname = 'CLARKE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MARK', 'CLARKE', 'MCLARKE', 'password')
end


if not exists (select * from bss_member where firstname = 'KEVIN' and lastname = 'CLENDENNIN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('KEVIN', 'CLENDENNIN', 'KCLENDENNIN', 'password')
end


if not exists (select * from bss_member where firstname = 'MORGAN' and lastname = 'CLENDENNIN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MORGAN', 'CLENDENNIN', 'MCLENDENNIN', 'password')
end


if not exists (select * from bss_member where firstname = 'FRANCOIS' and lastname = 'COEYTAUX') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('FRANCOIS', 'COEYTAUX', 'FCOEYTAUX', 'password')
end


if not exists (select * from bss_member where firstname = 'AMES' and lastname = 'COLT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('AMES', 'COLT', 'ACOLT', 'password')
end


if not exists (select * from bss_member where firstname = 'AMES' and lastname = 'COLT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('AMES', 'COLT', 'ACOLT', 'password')
end


if not exists (select * from bss_member where firstname = 'NIKOLA' and lastname = 'COOPER-FATEYER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('NIKOLA', 'COOPER-FATEYER', 'NCOOPER-FATEYER', 'password')
end


if not exists (select * from bss_member where firstname = 'KATHRYN' and lastname = 'CORBETT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('KATHRYN', 'CORBETT', 'KCORBETT', 'password')
end


if not exists (select * from bss_member where firstname = 'HUNTER' and lastname = 'CORMIER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('HUNTER', 'CORMIER', 'HCORMIER', 'password')
end


if not exists (select * from bss_member where firstname = 'EMILY' and lastname = 'COUGHLIN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('EMILY', 'COUGHLIN', 'ECOUGHLIN', 'password')
end


if not exists (select * from bss_member where firstname = 'GARY' and lastname = 'COYNE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GARY', 'COYNE', 'GCOYNE', 'password')
end


if not exists (select * from bss_member where firstname = 'SARA' and lastname = 'CRISAFI') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('SARA', 'CRISAFI', 'SCRISAFI', 'password')
end


if not exists (select * from bss_member where firstname = 'LANE' and lastname = 'CUNEO') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('LANE', 'CUNEO', 'LCUNEO', 'password')
end


if not exists (select * from bss_member where firstname = 'JACK' and lastname = 'CURLETTI') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JACK', 'CURLETTI', 'JCURLETTI', 'password')
end


if not exists (select * from bss_member where firstname = 'WILL' and lastname = 'CURLETTI') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('WILL', 'CURLETTI', 'WCURLETTI', 'password')
end


if not exists (select * from bss_member where firstname = 'TOM' and lastname = 'CURTIN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('TOM', 'CURTIN', 'TCURTIN', 'password')
end


if not exists (select * from bss_member where firstname = 'STEFANIE' and lastname = 'D''ANGELO') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('STEFANIE', 'D''ANGELO', 'SD''ANGELO', 'password')
end


if not exists (select * from bss_member where firstname = 'STEFANIE' and lastname = 'DANGELO') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('STEFANIE', 'DANGELO', 'SDANGELO', 'password')
end


if not exists (select * from bss_member where firstname = 'FOREST' and lastname = 'DAVIS HOLLANDER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('FOREST', 'DAVIS HOLLANDER', 'FDAVIS HOLLANDER', 'password')
end


if not exists (select * from bss_member where firstname = 'SAM' and lastname = 'DENARD') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('SAM', 'DENARD', 'SDENARD', 'password')
end


if not exists (select * from bss_member where firstname = 'ALAN' and lastname = 'DEVERRY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ALAN', 'DEVERRY', 'ADEVERRY', 'password')
end


if not exists (select * from bss_member where firstname = 'RHAE' and lastname = 'DEVERRY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('RHAE', 'DEVERRY', 'RDEVERRY', 'password')
end


if not exists (select * from bss_member where firstname = 'CHRIS' and lastname = 'DINAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CHRIS', 'DINAN', 'CDINAN', 'password')
end


if not exists (select * from bss_member where firstname = 'JAKE' and lastname = 'DITMAR') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JAKE', 'DITMAR', 'JDITMAR', 'password')
end


if not exists (select * from bss_member where firstname = 'MATTHEW' and lastname = 'DONENFELD') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MATTHEW', 'DONENFELD', 'MDONENFELD', 'password')
end


if not exists (select * from bss_member where firstname = 'BRENDAN' and lastname = 'DORSEY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('BRENDAN', 'DORSEY', 'BDORSEY', 'password')
end


if not exists (select * from bss_member where firstname = 'MEAGAN' and lastname = 'DORSEY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MEAGAN', 'DORSEY', 'MDORSEY', 'password')
end


if not exists (select * from bss_member where firstname = 'MATTHEW' and lastname = 'DOWD') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MATTHEW', 'DOWD', 'MDOWD', 'password')
end


if not exists (select * from bss_member where firstname = 'WILL' and lastname = 'DUBOCQ') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('WILL', 'DUBOCQ', 'WDUBOCQ', 'password')
end


if not exists (select * from bss_member where firstname = 'EVAN' and lastname = 'DUZAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('EVAN', 'DUZAN', 'EDUZAN', 'password')
end


if not exists (select * from bss_member where firstname = 'BEGONIA' and lastname = 'EL KOURY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('BEGONIA', 'EL KOURY', 'BEL KOURY', 'password')
end


if not exists (select * from bss_member where firstname = 'JAIME' and lastname = 'EL KOURY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JAIME', 'EL KOURY', 'JEL KOURY', 'password')
end


if not exists (select * from bss_member where firstname = 'JORGE' and lastname = 'EL KOURY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JORGE', 'EL KOURY', 'JEL KOURY', 'password')
end


if not exists (select * from bss_member where firstname = 'LEILA' and lastname = 'ENGLISH') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('LEILA', 'ENGLISH', 'LENGLISH', 'password')
end


if not exists (select * from bss_member where firstname = 'HERB' and lastname = 'ESCHBACH') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('HERB', 'ESCHBACH', 'HESCHBACH', 'password')
end


if not exists (select * from bss_member where firstname = 'DENNY' and lastname = 'FAHEY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DENNY', 'FAHEY', 'DFAHEY', 'password')
end


if not exists (select * from bss_member where firstname = 'RYAN' and lastname = 'FAHEY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('RYAN', 'FAHEY', 'RFAHEY', 'password')
end


if not exists (select * from bss_member where firstname = 'BENJAMIN' and lastname = 'FASCIANO') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('BENJAMIN', 'FASCIANO', 'BFASCIANO', 'password')
end


if not exists (select * from bss_member where firstname = 'BRENDAN' and lastname = 'FETZER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('BRENDAN', 'FETZER', 'BFETZER', 'password')
end


if not exists (select * from bss_member where firstname = 'ZACHARY H' and lastname = 'FIFE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ZACHARY H', 'FIFE', 'ZFIFE', 'password')
end


if not exists (select * from bss_member where firstname = 'GREG' and lastname = 'FISKE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GREG', 'FISKE', 'GFISKE', 'password')
end


if not exists (select * from bss_member where firstname = 'EMMA' and lastname = 'FOLEY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('EMMA', 'FOLEY', 'EFOLEY', 'password')
end


if not exists (select * from bss_member where firstname = 'TOM' and lastname = 'FOOTE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('TOM', 'FOOTE', 'TFOOTE', 'password')
end


if not exists (select * from bss_member where firstname = 'JOHNNY' and lastname = 'FREE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JOHNNY', 'FREE', 'JFREE', 'password')
end


if not exists (select * from bss_member where firstname = 'MAGGIE' and lastname = 'FREE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MAGGIE', 'FREE', 'MFREE', 'password')
end


if not exists (select * from bss_member where firstname = 'CHARLIE' and lastname = 'FRIEDBERG') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CHARLIE', 'FRIEDBERG', 'CFRIEDBERG', 'password')
end


if not exists (select * from bss_member where firstname = 'GAELEN' and lastname = 'FRINK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GAELEN', 'FRINK', 'GFRINK', 'password')
end


if not exists (select * from bss_member where firstname = 'HANNAH' and lastname = 'GARVEY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('HANNAH', 'GARVEY', 'HGARVEY', 'password')
end


if not exists (select * from bss_member where firstname = 'MATT' and lastname = 'GILLETTE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MATT', 'GILLETTE', 'MGILLETTE', 'password')
end


if not exists (select * from bss_member where firstname = 'MELINDA' and lastname = 'GILLETTE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MELINDA', 'GILLETTE', 'MGILLETTE', 'password')
end


if not exists (select * from bss_member where firstname = 'ERIC' and lastname = 'GIULIANO') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ERIC', 'GIULIANO', 'EGIULIANO', 'password')
end


if not exists (select * from bss_member where firstname = 'ETHAN' and lastname = 'GOROFF') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ETHAN', 'GOROFF', 'EGOROFF', 'password')
end


if not exists (select * from bss_member where firstname = 'CAROLINE' and lastname = 'GRANT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CAROLINE', 'GRANT', 'CGRANT', 'password')
end


if not exists (select * from bss_member where firstname = 'NICK' and lastname = 'GRAY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('NICK', 'GRAY', 'NGRAY', 'password')
end


if not exists (select * from bss_member where firstname = 'MICHAEL' and lastname = 'GREENBAUM') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MICHAEL', 'GREENBAUM', 'MGREENBAUM', 'password')
end


if not exists (select * from bss_member where firstname = 'JULIA' and lastname = 'GROEBER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JULIA', 'GROEBER', 'JGROEBER', 'password')
end


if not exists (select * from bss_member where firstname = 'REBECCA' and lastname = 'GROSSMA') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('REBECCA', 'GROSSMA', 'RGROSSMA', 'password')
end


if not exists (select * from bss_member where firstname = 'SARA' and lastname = 'GROVES') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('SARA', 'GROVES', 'SGROVES', 'password')
end


if not exists (select * from bss_member where firstname = 'CHRISTOFER' and lastname = 'GSCHWIND') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CHRISTOFER', 'GSCHWIND', 'CGSCHWIND', 'password')
end


if not exists (select * from bss_member where firstname = 'MARK' and lastname = 'GSCHWIND') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MARK', 'GSCHWIND', 'MGSCHWIND', 'password')
end


if not exists (select * from bss_member where firstname = 'JOHN' and lastname = 'GULA') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JOHN', 'GULA', 'JGULA', 'password')
end


if not exists (select * from bss_member where firstname = 'CLAIRE' and lastname = 'GULICK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CLAIRE', 'GULICK', 'CGULICK', 'password')
end


if not exists (select * from bss_member where firstname = 'DONN' and lastname = 'GULICK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DONN', 'GULICK', 'DGULICK', 'password')
end


if not exists (select * from bss_member where firstname = 'PETER' and lastname = 'HABICHT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('PETER', 'HABICHT', 'PHABICHT', 'password')
end


if not exists (select * from bss_member where firstname = 'JIM' and lastname = 'HAGEN, SR.') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JIM', 'HAGEN, SR.', 'JHAGEN, SR.', 'password')
end


if not exists (select * from bss_member where firstname = 'JAY' and lastname = 'HALL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JAY', 'HALL', 'JHALL', 'password')
end


if not exists (select * from bss_member where firstname = 'TYLER' and lastname = 'HARRINGTON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('TYLER', 'HARRINGTON', 'THARRINGTON', 'password')
end


if not exists (select * from bss_member where firstname = 'JIM' and lastname = 'HARRISON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JIM', 'HARRISON', 'JHARRISON', 'password')
end


if not exists (select * from bss_member where firstname = 'BENJAMAN' and lastname = 'HIGA') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('BENJAMAN', 'HIGA', 'BHIGA', 'password')
end


if not exists (select * from bss_member where firstname = 'RAY' and lastname = 'HINMAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('RAY', 'HINMAN', 'RHINMAN', 'password')
end


if not exists (select * from bss_member where firstname = 'RAY' and lastname = 'HINMAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('RAY', 'HINMAN', 'RHINMAN', 'password')
end


if not exists (select * from bss_member where firstname = 'AUGUST' and lastname = 'HOCHMAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('AUGUST', 'HOCHMAN', 'AHOCHMAN', 'password')
end


if not exists (select * from bss_member where firstname = 'ISABEL' and lastname = 'HOCHMAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ISABEL', 'HOCHMAN', 'IHOCHMAN', 'password')
end


if not exists (select * from bss_member where firstname = 'ISABEL' and lastname = 'HOCHMAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ISABEL', 'HOCHMAN', 'IHOCHMAN', 'password')
end


if not exists (select * from bss_member where firstname = 'JACOB' and lastname = 'HONIG') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JACOB', 'HONIG', 'JHONIG', 'password')
end


if not exists (select * from bss_member where firstname = 'JEFFREY' and lastname = 'HOROWITZ') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JEFFREY', 'HOROWITZ', 'JHOROWITZ', 'password')
end


if not exists (select * from bss_member where firstname = 'MARC' and lastname = 'HOROWITZ') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MARC', 'HOROWITZ', 'MHOROWITZ', 'password')
end


if not exists (select * from bss_member where firstname = 'ROGER' and lastname = 'HULL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ROGER', 'HULL', 'RHULL', 'password')
end


if not exists (select * from bss_member where firstname = 'KEIRSTEN' and lastname = 'HUTTIG WILLIAMS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('KEIRSTEN', 'HUTTIG WILLIAMS', 'KHUTTIG WILLIAMS', 'password')
end


if not exists (select * from bss_member where firstname = 'SUSAN' and lastname = 'HYDE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('SUSAN', 'HYDE', 'SHYDE', 'password')
end


if not exists (select * from bss_member where firstname = 'MARK' and lastname = 'IANNONE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MARK', 'IANNONE', 'MIANNONE', 'password')
end


if not exists (select * from bss_member where firstname = 'GABE' and lastname = 'IBANEZ') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GABE', 'IBANEZ', 'GIBANEZ', 'password')
end


if not exists (select * from bss_member where firstname = 'OLIVIA' and lastname = 'JAFFE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('OLIVIA', 'JAFFE', 'OJAFFE', 'password')
end


if not exists (select * from bss_member where firstname = 'EMILY' and lastname = 'JENKINS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('EMILY', 'JENKINS', 'EJENKINS', 'password')
end


if not exists (select * from bss_member where firstname = 'JOHN' and lastname = 'JEPSON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JOHN', 'JEPSON', 'JJEPSON', 'password')
end


if not exists (select * from bss_member where firstname = 'JOHN' and lastname = 'JEPSON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JOHN', 'JEPSON', 'JJEPSON', 'password')
end


if not exists (select * from bss_member where firstname = 'JOHN' and lastname = 'JEPSON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JOHN', 'JEPSON', 'JJEPSON', 'password')
end


if not exists (select * from bss_member where firstname = 'JASMIN' and lastname = 'JOHANNSDOTTIR') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JASMIN', 'JOHANNSDOTTIR', 'JJOHANNSDOTTIR', 'password')
end


if not exists (select * from bss_member where firstname = 'KATE' and lastname = 'JOHNSON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('KATE', 'JOHNSON', 'KJOHNSON', 'password')
end


if not exists (select * from bss_member where firstname = 'STEPHEN' and lastname = 'KALPIN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('STEPHEN', 'KALPIN', 'SKALPIN', 'password')
end


if not exists (select * from bss_member where firstname = 'STEVE' and lastname = 'KALPIN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('STEVE', 'KALPIN', 'SKALPIN', 'password')
end


if not exists (select * from bss_member where firstname = 'WILLIAM' and lastname = 'KANE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('WILLIAM', 'KANE', 'WKANE', 'password')
end


if not exists (select * from bss_member where firstname = 'GARY' and lastname = 'KAPCHINSKE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GARY', 'KAPCHINSKE', 'GKAPCHINSKE', 'password')
end


if not exists (select * from bss_member where firstname = 'CHRISTOPHER' and lastname = 'KEEGAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CHRISTOPHER', 'KEEGAN', 'CKEEGAN', 'password')
end


if not exists (select * from bss_member where firstname = 'KATHLEEN' and lastname = 'KEEGAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('KATHLEEN', 'KEEGAN', 'KKEEGAN', 'password')
end


if not exists (select * from bss_member where firstname = 'TOBY' and lastname = 'KEENAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('TOBY', 'KEENAN', 'TKEENAN', 'password')
end


if not exists (select * from bss_member where firstname = 'DAVE' and lastname = 'KELLIHER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DAVE', 'KELLIHER', 'DKELLIHER', 'password')
end


if not exists (select * from bss_member where firstname = 'GREGG' and lastname = 'KIMBALL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GREGG', 'KIMBALL', 'GKIMBALL', 'password')
end


if not exists (select * from bss_member where firstname = 'ALAN' and lastname = 'KING') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ALAN', 'KING', 'AKING', 'password')
end


if not exists (select * from bss_member where firstname = 'ALAN' and lastname = 'KING') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ALAN', 'KING', 'AKING', 'password')
end


if not exists (select * from bss_member where firstname = 'ALAN' and lastname = 'KING') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ALAN', 'KING', 'AKING', 'password')
end


if not exists (select * from bss_member where firstname = 'TYLER' and lastname = 'KING') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('TYLER', 'KING', 'TKING', 'password')
end


if not exists (select * from bss_member where firstname = 'WILLIAM' and lastname = 'KING') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('WILLIAM', 'KING', 'WKING', 'password')
end


if not exists (select * from bss_member where firstname = 'MARTHA' and lastname = 'KLEIN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MARTHA', 'KLEIN', 'MKLEIN', 'password')
end


if not exists (select * from bss_member where firstname = 'MARTHA' and lastname = 'KLEIN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MARTHA', 'KLEIN', 'MKLEIN', 'password')
end


if not exists (select * from bss_member where firstname = 'EMMA' and lastname = 'KLIMKOSKY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('EMMA', 'KLIMKOSKY', 'EKLIMKOSKY', 'password')
end


if not exists (select * from bss_member where firstname = 'MATT' and lastname = 'KLIMKOSKY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MATT', 'KLIMKOSKY', 'MKLIMKOSKY', 'password')
end


if not exists (select * from bss_member where firstname = 'GREG' and lastname = 'KNIGHT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GREG', 'KNIGHT', 'GKNIGHT', 'password')
end


if not exists (select * from bss_member where firstname = 'NIKKI' and lastname = 'KNIGHT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('NIKKI', 'KNIGHT', 'NKNIGHT', 'password')
end


if not exists (select * from bss_member where firstname = 'DAVID' and lastname = 'KOEHLER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DAVID', 'KOEHLER', 'DKOEHLER', 'password')
end


if not exists (select * from bss_member where firstname = 'GILLIAN' and lastname = 'KOTLEN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GILLIAN', 'KOTLEN', 'GKOTLEN', 'password')
end


if not exists (select * from bss_member where firstname = 'KK' and lastname = 'KOZIK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('KK', 'KOZIK', 'KKOZIK', 'password')
end


if not exists (select * from bss_member where firstname = 'MAGGIE' and lastname = 'KRATOVIL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MAGGIE', 'KRATOVIL', 'MKRATOVIL', 'password')
end


if not exists (select * from bss_member where firstname = 'JAMES' and lastname = 'KUHNLY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JAMES', 'KUHNLY', 'JKUHNLY', 'password')
end


if not exists (select * from bss_member where firstname = 'ANTHONY' and lastname = 'LABRASCA') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ANTHONY', 'LABRASCA', 'ALABRASCA', 'password')
end


if not exists (select * from bss_member where firstname = 'JOEY' and lastname = 'LABRASCA') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JOEY', 'LABRASCA', 'JLABRASCA', 'password')
end


if not exists (select * from bss_member where firstname = 'MEGAN' and lastname = 'LACOMBE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MEGAN', 'LACOMBE', 'MLACOMBE', 'password')
end


if not exists (select * from bss_member where firstname = 'MEGAN' and lastname = 'LACOMBE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MEGAN', 'LACOMBE', 'MLACOMBE', 'password')
end


if not exists (select * from bss_member where firstname = 'JOHN' and lastname = 'LAGATTUTA') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JOHN', 'LAGATTUTA', 'JLAGATTUTA', 'password')
end


if not exists (select * from bss_member where firstname = 'KIMBERLY' and lastname = 'LAMARCHE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('KIMBERLY', 'LAMARCHE', 'KLAMARCHE', 'password')
end


if not exists (select * from bss_member where firstname = 'GARY' and lastname = 'LARESE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GARY', 'LARESE', 'GLARESE', 'password')
end


if not exists (select * from bss_member where firstname = 'SCOTT' and lastname = 'LAROCHELLE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('SCOTT', 'LAROCHELLE', 'SLAROCHELLE', 'password')
end


if not exists (select * from bss_member where firstname = 'ELIZABETH' and lastname = 'LAVALLEE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ELIZABETH', 'LAVALLEE', 'ELAVALLEE', 'password')
end


if not exists (select * from bss_member where firstname = 'KATHRYN' and lastname = 'LAVALLEE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('KATHRYN', 'LAVALLEE', 'KLAVALLEE', 'password')
end


if not exists (select * from bss_member where firstname = 'VICTORIA' and lastname = 'LAVALLEE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('VICTORIA', 'LAVALLEE', 'VLAVALLEE', 'password')
end


if not exists (select * from bss_member where firstname = 'CLAIRE' and lastname = 'LAVERS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CLAIRE', 'LAVERS', 'CLAVERS', 'password')
end


if not exists (select * from bss_member where firstname = 'LINDSAY' and lastname = 'LEBRECHT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('LINDSAY', 'LEBRECHT', 'LLEBRECHT', 'password')
end


if not exists (select * from bss_member where firstname = 'KAITLIN' and lastname = 'LECCE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('KAITLIN', 'LECCE', 'KLECCE', 'password')
end


if not exists (select * from bss_member where firstname = 'KRISTEN' and lastname = 'LECCE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('KRISTEN', 'LECCE', 'KLECCE', 'password')
end


if not exists (select * from bss_member where firstname = 'JOHN' and lastname = 'LEE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JOHN', 'LEE', 'JLEE', 'password')
end


if not exists (select * from bss_member where firstname = 'JOHN' and lastname = 'LEE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JOHN', 'LEE', 'JLEE', 'password')
end


if not exists (select * from bss_member where firstname = 'BRIAN' and lastname = 'LEHNING') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('BRIAN', 'LEHNING', 'BLEHNING', 'password')
end


if not exists (select * from bss_member where firstname = 'VICTORIA' and lastname = 'LEHNING') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('VICTORIA', 'LEHNING', 'VLEHNING', 'password')
end


if not exists (select * from bss_member where firstname = 'RYAN' and lastname = 'LENNARD') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('RYAN', 'LENNARD', 'RLENNARD', 'password')
end


if not exists (select * from bss_member where firstname = 'MARK' and lastname = 'LEVI') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MARK', 'LEVI', 'MLEVI', 'password')
end


if not exists (select * from bss_member where firstname = 'JARED' and lastname = 'LEWIS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JARED', 'LEWIS', 'JLEWIS', 'password')
end


if not exists (select * from bss_member where firstname = 'JARED' and lastname = 'LEWIS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JARED', 'LEWIS', 'JLEWIS', 'password')
end


if not exists (select * from bss_member where firstname = 'JARED' and lastname = 'LEWIS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JARED', 'LEWIS', 'JLEWIS', 'password')
end


if not exists (select * from bss_member where firstname = 'AL' and lastname = 'LIEB') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('AL', 'LIEB', 'ALIEB', 'password')
end


if not exists (select * from bss_member where firstname = 'BEN' and lastname = 'LIPPMAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('BEN', 'LIPPMAN', 'BLIPPMAN', 'password')
end


if not exists (select * from bss_member where firstname = 'ERIC' and lastname = 'LIPPMAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ERIC', 'LIPPMAN', 'ELIPPMAN', 'password')
end


if not exists (select * from bss_member where firstname = 'ELLA' and lastname = 'LONG') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ELLA', 'LONG', 'ELONG', 'password')
end


if not exists (select * from bss_member where firstname = 'DYLAN' and lastname = 'LUBECK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DYLAN', 'LUBECK', 'DLUBECK', 'password')
end


if not exists (select * from bss_member where firstname = 'HANNAH' and lastname = 'LUBECK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('HANNAH', 'LUBECK', 'HLUBECK', 'password')
end


if not exists (select * from bss_member where firstname = 'ROLL' and lastname = 'LUSSIER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ROLL', 'LUSSIER', 'RLUSSIER', 'password')
end


if not exists (select * from bss_member where firstname = 'VERN' and lastname = 'LUSSIER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('VERN', 'LUSSIER', 'VLUSSIER', 'password')
end


if not exists (select * from bss_member where firstname = 'LOUISE' and lastname = 'LYNCH') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('LOUISE', 'LYNCH', 'LLYNCH', 'password')
end


if not exists (select * from bss_member where firstname = 'WILLIAM' and lastname = 'LYON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('WILLIAM', 'LYON', 'WLYON', 'password')
end


if not exists (select * from bss_member where firstname = 'ELIZA' and lastname = 'MAGGIO') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ELIZA', 'MAGGIO', 'EMAGGIO', 'password')
end


if not exists (select * from bss_member where firstname = 'SHAWN' and lastname = 'MAGILL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('SHAWN', 'MAGILL', 'SMAGILL', 'password')
end


if not exists (select * from bss_member where firstname = 'TINA' and lastname = 'MAGILL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('TINA', 'MAGILL', 'TMAGILL', 'password')
end


if not exists (select * from bss_member where firstname = 'CATE' and lastname = 'MAHONEY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CATE', 'MAHONEY', 'CMAHONEY', 'password')
end


if not exists (select * from bss_member where firstname = 'JACOB' and lastname = 'MAKUC') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JACOB', 'MAKUC', 'JMAKUC', 'password')
end


if not exists (select * from bss_member where firstname = 'BROOKE' and lastname = 'MARS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('BROOKE', 'MARS', 'BMARS', 'password')
end


if not exists (select * from bss_member where firstname = 'CLAUDIA' and lastname = 'MARTIN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CLAUDIA', 'MARTIN', 'CMARTIN', 'password')
end


if not exists (select * from bss_member where firstname = 'KEVIN' and lastname = 'MARZOTTO') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('KEVIN', 'MARZOTTO', 'KMARZOTTO', 'password')
end


if not exists (select * from bss_member where firstname = 'MASHO' and lastname = 'MCALISTER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MASHO', 'MCALISTER', 'MMCALISTER', 'password')
end


if not exists (select * from bss_member where firstname = 'WEYESSA' and lastname = 'MCALISTER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('WEYESSA', 'MCALISTER', 'WMCALISTER', 'password')
end


if not exists (select * from bss_member where firstname = 'CASEY' and lastname = 'MCCABE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CASEY', 'MCCABE', 'CMCCABE', 'password')
end


if not exists (select * from bss_member where firstname = 'ED' and lastname = 'MCCANN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ED', 'MCCANN', 'EMCCANN', 'password')
end


if not exists (select * from bss_member where firstname = 'JOHN' and lastname = 'MCCANN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JOHN', 'MCCANN', 'JMCCANN', 'password')
end


if not exists (select * from bss_member where firstname = 'LYNN' and lastname = 'MCCANN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('LYNN', 'MCCANN', 'LMCCANN', 'password')
end


if not exists (select * from bss_member where firstname = 'PETER' and lastname = 'MCCANN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('PETER', 'MCCANN', 'PMCCANN', 'password')
end


if not exists (select * from bss_member where firstname = 'CEARA' and lastname = 'MCDONNELL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CEARA', 'MCDONNELL', 'CMCDONNELL', 'password')
end


if not exists (select * from bss_member where firstname = 'TOM' and lastname = 'MCDONNELL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('TOM', 'MCDONNELL', 'TMCDONNELL', 'password')
end


if not exists (select * from bss_member where firstname = 'IAN' and lastname = 'MCHUGH') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('IAN', 'MCHUGH', 'IMCHUGH', 'password')
end


if not exists (select * from bss_member where firstname = 'IAN' and lastname = 'MCHUGH') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('IAN', 'MCHUGH', 'IMCHUGH', 'password')
end


if not exists (select * from bss_member where firstname = 'ANGUS' and lastname = 'MCLAREN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ANGUS', 'MCLAREN', 'AMCLAREN', 'password')
end


if not exists (select * from bss_member where firstname = 'ANGUS' and lastname = 'MCLAREN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ANGUS', 'MCLAREN', 'AMCLAREN', 'password')
end


if not exists (select * from bss_member where firstname = 'ANGUS' and lastname = 'MCLAREN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ANGUS', 'MCLAREN', 'AMCLAREN', 'password')
end


if not exists (select * from bss_member where firstname = 'SINEAD' and lastname = 'MCNABOE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('SINEAD', 'MCNABOE', 'SMCNABOE', 'password')
end


if not exists (select * from bss_member where firstname = 'ANNIE' and lastname = 'MCVEIGH') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ANNIE', 'MCVEIGH', 'AMCVEIGH', 'password')
end


if not exists (select * from bss_member where firstname = 'COLIN' and lastname = 'MCVEIGH') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('COLIN', 'MCVEIGH', 'CMCVEIGH', 'password')
end


if not exists (select * from bss_member where firstname = 'BRAD' and lastname = 'MERENSTEIN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('BRAD', 'MERENSTEIN', 'BMERENSTEIN', 'password')
end


if not exists (select * from bss_member where firstname = 'BRUCE' and lastname = 'MERKIS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('BRUCE', 'MERKIS', 'BMERKIS', 'password')
end


if not exists (select * from bss_member where firstname = 'MARGARETH' and lastname = 'MESCHTER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MARGARETH', 'MESCHTER', 'MMESCHTER', 'password')
end


if not exists (select * from bss_member where firstname = 'DANIEL' and lastname = 'MILLER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DANIEL', 'MILLER', 'DMILLER', 'password')
end


if not exists (select * from bss_member where firstname = 'BARBARA' and lastname = 'MINKOFF') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('BARBARA', 'MINKOFF', 'BMINKOFF', 'password')
end


if not exists (select * from bss_member where firstname = 'ELIZA J.' and lastname = 'MITCHELL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ELIZA J.', 'MITCHELL', 'EMITCHELL', 'password')
end


if not exists (select * from bss_member where firstname = 'ISABEL S.' and lastname = 'MITCHELL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ISABEL S.', 'MITCHELL', 'IMITCHELL', 'password')
end


if not exists (select * from bss_member where firstname = 'SAMANTHA' and lastname = 'MITCHELL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('SAMANTHA', 'MITCHELL', 'SMITCHELL', 'password')
end


if not exists (select * from bss_member where firstname = 'GARY' and lastname = 'MORRIS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GARY', 'MORRIS', 'GMORRIS', 'password')
end


if not exists (select * from bss_member where firstname = 'GEORGE' and lastname = 'MOSLER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GEORGE', 'MOSLER', 'GMOSLER', 'password')
end


if not exists (select * from bss_member where firstname = 'GEORGE' and lastname = 'MOSLER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GEORGE', 'MOSLER', 'GMOSLER', 'password')
end


if not exists (select * from bss_member where firstname = 'GEORGE' and lastname = 'MOSLER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GEORGE', 'MOSLER', 'GMOSLER', 'password')
end


if not exists (select * from bss_member where firstname = 'THOMAS' and lastname = 'MOSLER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('THOMAS', 'MOSLER', 'TMOSLER', 'password')
end


if not exists (select * from bss_member where firstname = 'ELIE' and lastname = 'MOUCHANTAT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ELIE', 'MOUCHANTAT', 'EMOUCHANTAT', 'password')
end


if not exists (select * from bss_member where firstname = 'MICHAEL' and lastname = 'MOUCHANTAT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MICHAEL', 'MOUCHANTAT', 'MMOUCHANTAT', 'password')
end


if not exists (select * from bss_member where firstname = 'NICK' and lastname = 'MURNER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('NICK', 'MURNER', 'NMURNER', 'password')
end


if not exists (select * from bss_member where firstname = 'ROBERT' and lastname = 'MURNER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ROBERT', 'MURNER', 'RMURNER', 'password')
end


if not exists (select * from bss_member where firstname = 'JESSICA' and lastname = 'MUSIAK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JESSICA', 'MUSIAK', 'JMUSIAK', 'password')
end


if not exists (select * from bss_member where firstname = 'HANNAH' and lastname = 'MUSKA') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('HANNAH', 'MUSKA', 'HMUSKA', 'password')
end


if not exists (select * from bss_member where firstname = 'HANNAH' and lastname = 'MUSKA') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('HANNAH', 'MUSKA', 'HMUSKA', 'password')
end


if not exists (select * from bss_member where firstname = 'JOSHUA' and lastname = 'MUSKA') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JOSHUA', 'MUSKA', 'JMUSKA', 'password')
end


if not exists (select * from bss_member where firstname = 'JOSHUA' and lastname = 'MUSKA') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JOSHUA', 'MUSKA', 'JMUSKA', 'password')
end


if not exists (select * from bss_member where firstname = 'JAKE' and lastname = 'NADLER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JAKE', 'NADLER', 'JNADLER', 'password')
end


if not exists (select * from bss_member where firstname = 'JON' and lastname = 'NELSON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JON', 'NELSON', 'JNELSON', 'password')
end


if not exists (select * from bss_member where firstname = 'JOSHUA' and lastname = 'NELSON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JOSHUA', 'NELSON', 'JNELSON', 'password')
end


if not exists (select * from bss_member where firstname = 'MORIAH' and lastname = 'NELSON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MORIAH', 'NELSON', 'MNELSON', 'password')
end


if not exists (select * from bss_member where firstname = 'EVAN' and lastname = 'NEWMAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('EVAN', 'NEWMAN', 'ENEWMAN', 'password')
end


if not exists (select * from bss_member where firstname = 'JEREMY' and lastname = 'NOEL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JEREMY', 'NOEL', 'JNOEL', 'password')
end


if not exists (select * from bss_member where firstname = 'NATHAN' and lastname = 'NOEL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('NATHAN', 'NOEL', 'NNOEL', 'password')
end


if not exists (select * from bss_member where firstname = 'SAVANNA' and lastname = 'NOLAU') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('SAVANNA', 'NOLAU', 'SNOLAU', 'password')
end


if not exists (select * from bss_member where firstname = 'ERIK' and lastname = 'NORDMARK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ERIK', 'NORDMARK', 'ENORDMARK', 'password')
end


if not exists (select * from bss_member where firstname = 'LIANE' and lastname = 'NOURI') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('LIANE', 'NOURI', 'LNOURI', 'password')
end


if not exists (select * from bss_member where firstname = 'MICHAEL' and lastname = 'NOURI') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MICHAEL', 'NOURI', 'MNOURI', 'password')
end


if not exists (select * from bss_member where firstname = 'KARL' and lastname = 'OPPENHEIMER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('KARL', 'OPPENHEIMER', 'KOPPENHEIMER', 'password')
end


if not exists (select * from bss_member where firstname = 'WARREN' and lastname = 'PALMER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('WARREN', 'PALMER', 'WPALMER', 'password')
end


if not exists (select * from bss_member where firstname = 'MARY' and lastname = 'PANAGROSSO') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MARY', 'PANAGROSSO', 'MPANAGROSSO', 'password')
end


if not exists (select * from bss_member where firstname = 'SIERRA' and lastname = 'PARDUS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('SIERRA', 'PARDUS', 'SPARDUS', 'password')
end


if not exists (select * from bss_member where firstname = 'YOONHO' and lastname = 'PARK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('YOONHO', 'PARK', 'YPARK', 'password')
end


if not exists (select * from bss_member where firstname = 'MATTHEW' and lastname = 'PARKES') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MATTHEW', 'PARKES', 'MPARKES', 'password')
end


if not exists (select * from bss_member where firstname = 'DAN' and lastname = 'PATEL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DAN', 'PATEL', 'DPATEL', 'password')
end


if not exists (select * from bss_member where firstname = 'ERIC' and lastname = 'PATTISON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ERIC', 'PATTISON', 'EPATTISON', 'password')
end


if not exists (select * from bss_member where firstname = 'HAROLD' and lastname = 'PATZELT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('HAROLD', 'PATZELT', 'HPATZELT', 'password')
end


if not exists (select * from bss_member where firstname = 'NICHOLAS' and lastname = 'PAUL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('NICHOLAS', 'PAUL', 'NPAUL', 'password')
end


if not exists (select * from bss_member where firstname = 'THOMAS' and lastname = 'PELLATT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('THOMAS', 'PELLATT', 'TPELLATT', 'password')
end


if not exists (select * from bss_member where firstname = 'TONY' and lastname = 'PERCIVALLE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('TONY', 'PERCIVALLE', 'TPERCIVALLE', 'password')
end


if not exists (select * from bss_member where firstname = 'ELIZABETH' and lastname = 'PERKINS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ELIZABETH', 'PERKINS', 'EPERKINS', 'password')
end


if not exists (select * from bss_member where firstname = 'DAVE' and lastname = 'PESCHEL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DAVE', 'PESCHEL', 'DPESCHEL', 'password')
end


if not exists (select * from bss_member where firstname = 'ALEXA' and lastname = 'PFEIFFER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ALEXA', 'PFEIFFER', 'APFEIFFER', 'password')
end


if not exists (select * from bss_member where firstname = 'ALEXA' and lastname = 'PFEIFFER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ALEXA', 'PFEIFFER', 'APFEIFFER', 'password')
end


if not exists (select * from bss_member where firstname = 'MERYL' and lastname = 'PHAIR') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MERYL', 'PHAIR', 'MPHAIR', 'password')
end


if not exists (select * from bss_member where firstname = 'KARLI' and lastname = 'PIANOWSKI') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('KARLI', 'PIANOWSKI', 'KPIANOWSKI', 'password')
end


if not exists (select * from bss_member where firstname = 'NATHAN' and lastname = 'PIANTEK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('NATHAN', 'PIANTEK', 'NPIANTEK', 'password')
end


if not exists (select * from bss_member where firstname = 'HEATHER' and lastname = 'PINKHAM') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('HEATHER', 'PINKHAM', 'HPINKHAM', 'password')
end


if not exists (select * from bss_member where firstname = 'GEORGENE' and lastname = 'POLIAK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GEORGENE', 'POLIAK', 'GPOLIAK', 'password')
end


if not exists (select * from bss_member where firstname = 'GEORGENE' and lastname = 'POLIAK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GEORGENE', 'POLIAK', 'GPOLIAK', 'password')
end


if not exists (select * from bss_member where firstname = 'ANTHONY' and lastname = 'POLYAK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ANTHONY', 'POLYAK', 'APOLYAK', 'password')
end


if not exists (select * from bss_member where firstname = 'KATTY' and lastname = 'POLYAK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('KATTY', 'POLYAK', 'KPOLYAK', 'password')
end


if not exists (select * from bss_member where firstname = 'DANIEL' and lastname = 'POMERANTZ') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DANIEL', 'POMERANTZ', 'DPOMERANTZ', 'password')
end


if not exists (select * from bss_member where firstname = 'LUCAS' and lastname = 'POTTER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('LUCAS', 'POTTER', 'LPOTTER', 'password')
end


if not exists (select * from bss_member where firstname = 'JUSTIN' and lastname = 'PRATT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JUSTIN', 'PRATT', 'JPRATT', 'password')
end


if not exists (select * from bss_member where firstname = 'LOIS' and lastname = 'QUARTARARO') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('LOIS', 'QUARTARARO', 'LQUARTARARO', 'password')
end


if not exists (select * from bss_member where firstname = 'DAVID' and lastname = 'QUISENBERRY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DAVID', 'QUISENBERRY', 'DQUISENBERRY', 'password')
end


if not exists (select * from bss_member where firstname = 'GRAHAM' and lastname = 'QUISENBERRY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GRAHAM', 'QUISENBERRY', 'GQUISENBERRY', 'password')
end


if not exists (select * from bss_member where firstname = 'JENNIFER' and lastname = 'QUISENBERRY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JENNIFER', 'QUISENBERRY', 'JQUISENBERRY', 'password')
end


if not exists (select * from bss_member where firstname = 'PAUL' and lastname = 'REED') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('PAUL', 'REED', 'PREED', 'password')
end


if not exists (select * from bss_member where firstname = 'PAUL' and lastname = 'REED') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('PAUL', 'REED', 'PREED', 'password')
end


if not exists (select * from bss_member where firstname = 'ALISON' and lastname = 'REGGIANNINI') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ALISON', 'REGGIANNINI', 'AREGGIANNINI', 'password')
end


if not exists (select * from bss_member where firstname = 'COURTNEY' and lastname = 'REGGIANNINI') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('COURTNEY', 'REGGIANNINI', 'CREGGIANNINI', 'password')
end


if not exists (select * from bss_member where firstname = 'JAMES' and lastname = 'RICE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JAMES', 'RICE', 'JRICE', 'password')
end


if not exists (select * from bss_member where firstname = 'JAMIE' and lastname = 'RICE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JAMIE', 'RICE', 'JRICE', 'password')
end


if not exists (select * from bss_member where firstname = 'ALEXANDRA' and lastname = 'RIX') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ALEXANDRA', 'RIX', 'ARIX', 'password')
end


if not exists (select * from bss_member where firstname = 'RON' and lastname = 'RIX') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('RON', 'RIX', 'RRIX', 'password')
end


if not exists (select * from bss_member where firstname = 'GAIL' and lastname = 'ROGER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GAIL', 'ROGER', 'GROGER', 'password')
end


if not exists (select * from bss_member where firstname = 'LEONCE' and lastname = 'ROGER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('LEONCE', 'ROGER', 'LROGER', 'password')
end


if not exists (select * from bss_member where firstname = 'JACOB' and lastname = 'ROSEN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JACOB', 'ROSEN', 'JROSEN', 'password')
end


if not exists (select * from bss_member where firstname = 'GILLIAN' and lastname = 'ROSH') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GILLIAN', 'ROSH', 'GROSH', 'password')
end


if not exists (select * from bss_member where firstname = 'JULIANNE' and lastname = 'ROSSI') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JULIANNE', 'ROSSI', 'JROSSI', 'password')
end


if not exists (select * from bss_member where firstname = 'JENNA' and lastname = 'ROTHERMEL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JENNA', 'ROTHERMEL', 'JROTHERMEL', 'password')
end


if not exists (select * from bss_member where firstname = 'NATHANIEL' and lastname = 'ROY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('NATHANIEL', 'ROY', 'NROY', 'password')
end


if not exists (select * from bss_member where firstname = 'RON' and lastname = 'RYASON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('RON', 'RYASON', 'RRYASON', 'password')
end


if not exists (select * from bss_member where firstname = 'NICHOLAS' and lastname = 'SAGARIN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('NICHOLAS', 'SAGARIN', 'NSAGARIN', 'password')
end


if not exists (select * from bss_member where firstname = 'JENNY' and lastname = 'SAGE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JENNY', 'SAGE', 'JSAGE', 'password')
end


if not exists (select * from bss_member where firstname = 'JIM' and lastname = 'SALIBA') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JIM', 'SALIBA', 'JSALIBA', 'password')
end


if not exists (select * from bss_member where firstname = 'JIMMY' and lastname = 'SALINA') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JIMMY', 'SALINA', 'JSALINA', 'password')
end


if not exists (select * from bss_member where firstname = 'DANIEL' and lastname = 'SANTOS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DANIEL', 'SANTOS', 'DSANTOS', 'password')
end


if not exists (select * from bss_member where firstname = 'WALTER' and lastname = 'SARAMAK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('WALTER', 'SARAMAK', 'WSARAMAK', 'password')
end


if not exists (select * from bss_member where firstname = 'ASPEN' and lastname = 'SAWYER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ASPEN', 'SAWYER', 'ASAWYER', 'password')
end


if not exists (select * from bss_member where firstname = 'PETER' and lastname = 'SCARPELLI') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('PETER', 'SCARPELLI', 'PSCARPELLI', 'password')
end


if not exists (select * from bss_member where firstname = 'HELGA' and lastname = 'SCHEIDLE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('HELGA', 'SCHEIDLE', 'HSCHEIDLE', 'password')
end


if not exists (select * from bss_member where firstname = 'STUART' and lastname = 'SCHMALL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('STUART', 'SCHMALL', 'SSCHMALL', 'password')
end


if not exists (select * from bss_member where firstname = 'CAMERON' and lastname = 'SCOTT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CAMERON', 'SCOTT', 'CSCOTT', 'password')
end


if not exists (select * from bss_member where firstname = 'ROBIN' and lastname = 'SEARING') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ROBIN', 'SEARING', 'RSEARING', 'password')
end


if not exists (select * from bss_member where firstname = 'SAM' and lastname = 'SECKLER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('SAM', 'SECKLER', 'SSECKLER', 'password')
end


if not exists (select * from bss_member where firstname = 'MURU' and lastname = 'SENTHILVELAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MURU', 'SENTHILVELAN', 'MSENTHILVELAN', 'password')
end


if not exists (select * from bss_member where firstname = 'JANE' and lastname = 'SHERWIN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JANE', 'SHERWIN', 'JSHERWIN', 'password')
end


if not exists (select * from bss_member where firstname = 'JANE' and lastname = 'SHERWIN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JANE', 'SHERWIN', 'JSHERWIN', 'password')
end


if not exists (select * from bss_member where firstname = 'JACOB' and lastname = 'SHIVERS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JACOB', 'SHIVERS', 'JSHIVERS', 'password')
end


if not exists (select * from bss_member where firstname = 'DOUGLAS' and lastname = 'SHUFELT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DOUGLAS', 'SHUFELT', 'DSHUFELT', 'password')
end


if not exists (select * from bss_member where firstname = 'DAVID' and lastname = 'SHULMAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DAVID', 'SHULMAN', 'DSHULMAN', 'password')
end


if not exists (select * from bss_member where firstname = 'GRACE' and lastname = 'SILVA') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GRACE', 'SILVA', 'GSILVA', 'password')
end


if not exists (select * from bss_member where firstname = 'LIZ' and lastname = 'SMITH') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('LIZ', 'SMITH', 'LSMITH', 'password')
end


if not exists (select * from bss_member where firstname = 'CHARLENE' and lastname = 'SMOLKOWICZ') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CHARLENE', 'SMOLKOWICZ', 'CSMOLKOWICZ', 'password')
end


if not exists (select * from bss_member where firstname = 'GEOFFREY' and lastname = 'SOKOLSKY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('GEOFFREY', 'SOKOLSKY', 'GSOKOLSKY', 'password')
end


if not exists (select * from bss_member where firstname = 'JONATHAN' and lastname = 'SOKOLSKY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JONATHAN', 'SOKOLSKY', 'JSOKOLSKY', 'password')
end


if not exists (select * from bss_member where firstname = 'MATTHEW' and lastname = 'SPENCE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MATTHEW', 'SPENCE', 'MSPENCE', 'password')
end


if not exists (select * from bss_member where firstname = 'CAROLINE' and lastname = 'SPRAGUE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CAROLINE', 'SPRAGUE', 'CSPRAGUE', 'password')
end


if not exists (select * from bss_member where firstname = 'MICHAEL' and lastname = 'STARK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MICHAEL', 'STARK', 'MSTARK', 'password')
end


if not exists (select * from bss_member where firstname = 'SEAN' and lastname = 'STEPHEN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('SEAN', 'STEPHEN', 'SSTEPHEN', 'password')
end


if not exists (select * from bss_member where firstname = 'JONATHAN' and lastname = 'STILES') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JONATHAN', 'STILES', 'JSTILES', 'password')
end


if not exists (select * from bss_member where firstname = 'CHASE' and lastname = 'STRAWN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CHASE', 'STRAWN', 'CSTRAWN', 'password')
end


if not exists (select * from bss_member where firstname = 'OLIVIA' and lastname = 'SUK') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('OLIVIA', 'SUK', 'OSUK', 'password')
end


if not exists (select * from bss_member where firstname = 'JACK' and lastname = 'SULLIVAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JACK', 'SULLIVAN', 'JSULLIVAN', 'password')
end


if not exists (select * from bss_member where firstname = 'EVAN' and lastname = 'SYLBERT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('EVAN', 'SYLBERT', 'ESYLBERT', 'password')
end


if not exists (select * from bss_member where firstname = 'ANGIE' and lastname = 'TAYLOR') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ANGIE', 'TAYLOR', 'ATAYLOR', 'password')
end


if not exists (select * from bss_member where firstname = 'STEVE' and lastname = 'TAYLOR') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('STEVE', 'TAYLOR', 'STAYLOR', 'password')
end


if not exists (select * from bss_member where firstname = 'JACOB' and lastname = 'TEICH') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JACOB', 'TEICH', 'JTEICH', 'password')
end


if not exists (select * from bss_member where firstname = 'HELENA' and lastname = 'THATCHER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('HELENA', 'THATCHER', 'HTHATCHER', 'password')
end


if not exists (select * from bss_member where firstname = 'LAURA' and lastname = 'THIBAULT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('LAURA', 'THIBAULT', 'LTHIBAULT', 'password')
end


if not exists (select * from bss_member where firstname = 'ZAC' and lastname = 'THOMAS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ZAC', 'THOMAS', 'ZTHOMAS', 'password')
end


if not exists (select * from bss_member where firstname = 'TREVOR' and lastname = 'THOMPSON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('TREVOR', 'THOMPSON', 'TTHOMPSON', 'password')
end


if not exists (select * from bss_member where firstname = 'CARTER' and lastname = 'THORNE-KAUNELIS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CARTER', 'THORNE-KAUNELIS', 'CTHORNE-KAUNELIS', 'password')
end


if not exists (select * from bss_member where firstname = 'KESTREL' and lastname = 'THORNE-KAUNELIS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('KESTREL', 'THORNE-KAUNELIS', 'KTHORNE-KAUNELIS', 'password')
end


if not exists (select * from bss_member where firstname = 'WINTER' and lastname = 'THORNE-KAUNELIS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('WINTER', 'THORNE-KAUNELIS', 'WTHORNE-KAUNELIS', 'password')
end


if not exists (select * from bss_member where firstname = 'FRENCHY' and lastname = 'TRUITT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('FRENCHY', 'TRUITT', 'FTRUITT', 'password')
end


if not exists (select * from bss_member where firstname = 'ROBERT' and lastname = 'TURTZ') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ROBERT', 'TURTZ', 'RTURTZ', 'password')
end


if not exists (select * from bss_member where firstname = 'NOAH' and lastname = 'ULLMAN') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('NOAH', 'ULLMAN', 'NULLMAN', 'password')
end


if not exists (select * from bss_member where firstname = 'DALE' and lastname = 'VANDERVOORT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DALE', 'VANDERVOORT', 'DVANDERVOORT', 'password')
end


if not exists (select * from bss_member where firstname = 'DARCY' and lastname = 'VICTORY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DARCY', 'VICTORY', 'DVICTORY', 'password')
end


if not exists (select * from bss_member where firstname = 'KAITLYN' and lastname = 'VICTORY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('KAITLYN', 'VICTORY', 'KVICTORY', 'password')
end


if not exists (select * from bss_member where firstname = 'STEVE' and lastname = 'VICTORY') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('STEVE', 'VICTORY', 'SVICTORY', 'password')
end


if not exists (select * from bss_member where firstname = 'DAMIAN' and lastname = 'VINCENT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DAMIAN', 'VINCENT', 'DVINCENT', 'password')
end


if not exists (select * from bss_member where firstname = 'NICHOLAS' and lastname = 'VISSCHER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('NICHOLAS', 'VISSCHER', 'NVISSCHER', 'password')
end


if not exists (select * from bss_member where firstname = 'ERIKA' and lastname = 'WAINWRIGHT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ERIKA', 'WAINWRIGHT', 'EWAINWRIGHT', 'password')
end


if not exists (select * from bss_member where firstname = 'CRAIG' and lastname = 'WARD') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CRAIG', 'WARD', 'CWARD', 'password')
end


if not exists (select * from bss_member where firstname = 'BEN' and lastname = 'WEBB') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('BEN', 'WEBB', 'BWEBB', 'password')
end


if not exists (select * from bss_member where firstname = 'MAX' and lastname = 'WEIDINGER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MAX', 'WEIDINGER', 'MWEIDINGER', 'password')
end


if not exists (select * from bss_member where firstname = 'JACOB' and lastname = 'WEINER') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JACOB', 'WEINER', 'JWEINER', 'password')
end


if not exists (select * from bss_member where firstname = 'PAT' and lastname = 'WHITE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('PAT', 'WHITE', 'PWHITE', 'password')
end


if not exists (select * from bss_member where firstname = 'JESSICA' and lastname = 'WIKLE') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JESSICA', 'WIKLE', 'JWIKLE', 'password')
end


if not exists (select * from bss_member where firstname = 'SAMUEL' and lastname = 'WILLIAMS') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('SAMUEL', 'WILLIAMS', 'SWILLIAMS', 'password')
end


if not exists (select * from bss_member where firstname = 'ELLIOT' and lastname = 'WILSON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('ELLIOT', 'WILSON', 'EWILSON', 'password')
end


if not exists (select * from bss_member where firstname = 'MAREN' and lastname = 'WILSON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MAREN', 'WILSON', 'MWILSON', 'password')
end


if not exists (select * from bss_member where firstname = 'CAITLIN' and lastname = 'WOOD') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('CAITLIN', 'WOOD', 'CWOOD', 'password')
end


if not exists (select * from bss_member where firstname = 'MOLLY' and lastname = 'WOOD') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('MOLLY', 'WOOD', 'MWOOD', 'password')
end


if not exists (select * from bss_member where firstname = 'PETER' and lastname = 'WOOD') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('PETER', 'WOOD', 'PWOOD', 'password')
end


if not exists (select * from bss_member where firstname = 'RILEY' and lastname = 'WOOD') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('RILEY', 'WOOD', 'RWOOD', 'password')
end


if not exists (select * from bss_member where firstname = 'FAREN' and lastname = 'WORTHINGTON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('FAREN', 'WORTHINGTON', 'FWORTHINGTON', 'password')
end


if not exists (select * from bss_member where firstname = 'NANCI' and lastname = 'WORTHINGTON') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('NANCI', 'WORTHINGTON', 'NWORTHINGTON', 'password')
end


if not exists (select * from bss_member where firstname = 'JEFFREY' and lastname = 'WRIGHT') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JEFFREY', 'WRIGHT', 'JWRIGHT', 'password')
end


if not exists (select * from bss_member where firstname = 'DORIS' and lastname = 'YOUMELL') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('DORIS', 'YOUMELL', 'DYOUMELL', 'password')
end


if not exists (select * from bss_member where firstname = 'JOSH' and lastname = 'ZINBERG') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('JOSH', 'ZINBERG', 'JZINBERG', 'password')
end


if not exists (select * from bss_member where firstname = 'RACHEL' and lastname = 'ZINBERG') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('RACHEL', 'ZINBERG', 'RZINBERG', 'password')
end


if not exists (select * from bss_member where firstname = 'EDWARD' and lastname = 'ZONENBERG') 
begin
insert into bss_member (firstname, lastname, username, [password]) values ('EDWARD', 'ZONENBERG', 'EZONENBERG', 'password')
end


declare @memberid uniqueidentifier
set @memberid = (select memberid from bss_Member where firstname = 'DAVID' and lastname = 'ALLGAIER' )
insert into bss_memberidcards (id, memberid, expires) values ('62847004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DAVID' and lastname = 'ALLGAIER' )
insert into bss_memberidcards (id, memberid, expires) values ('62055004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'RON' and lastname = 'ARDIZONI' )
insert into bss_memberidcards (id, memberid, expires) values ('62383004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'LARS' and lastname = 'ARIENTI' )
insert into bss_memberidcards (id, memberid, expires) values ('62463004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CALLIE' and lastname = 'ATWELL' )
insert into bss_memberidcards (id, memberid, expires) values ('61316004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'SANDRA' and lastname = 'AULD' )
insert into bss_memberidcards (id, memberid, expires) values ('62056004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JOE' and lastname = 'BAILEY' )
insert into bss_memberidcards (id, memberid, expires) values ('62057004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'VALERIE' and lastname = 'BAILEY' )
insert into bss_memberidcards (id, memberid, expires) values ('7145012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JASON' and lastname = 'BAKER' )
insert into bss_memberidcards (id, memberid, expires) values ('62095004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JESSE' and lastname = 'BARAN' )
insert into bss_memberidcards (id, memberid, expires) values ('62096004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JP' and lastname = 'BARBEAU' )
insert into bss_memberidcards (id, memberid, expires) values ('33703008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JAY' and lastname = 'BARRANGER' )
insert into bss_memberidcards (id, memberid, expires) values ('30495008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'THERESA' and lastname = 'BARRON' )
insert into bss_memberidcards (id, memberid, expires) values ('62058004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JOHN' and lastname = 'BARROWS' )
insert into bss_memberidcards (id, memberid, expires) values ('32092008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JOANN' and lastname = 'BELL' )
insert into bss_memberidcards (id, memberid, expires) values ('62402004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JOANNA' and lastname = 'BELL' )
insert into bss_memberidcards (id, memberid, expires) values ('62382004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MICHAEL' and lastname = 'BELLETZKE' )
insert into bss_memberidcards (id, memberid, expires) values ('31470008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'BEN' and lastname = 'BERGMAN' )
insert into bss_memberidcards (id, memberid, expires) values ('62543004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DAVID' and lastname = 'BJORKLUND' )
insert into bss_memberidcards (id, memberid, expires) values ('7499012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'LORI' and lastname = 'BLACK' )
insert into bss_memberidcards (id, memberid, expires) values ('32093008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'LORI' and lastname = 'BLACK' )
insert into bss_memberidcards (id, memberid, expires) values ('31471008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JUSTIN' and lastname = 'BONA' )
insert into bss_memberidcards (id, memberid, expires) values ('62097004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MONTGOMERY' and lastname = 'BOPP' )
insert into bss_memberidcards (id, memberid, expires) values ('62059004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JAKE' and lastname = 'BORDEN' )
insert into bss_memberidcards (id, memberid, expires) values ('34073008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ELISSA' and lastname = 'BOSWORTH' )
insert into bss_memberidcards (id, memberid, expires) values ('31837008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'EVELYN' and lastname = 'BOUCHARD' )
insert into bss_memberidcards (id, memberid, expires) values ('31451008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ROBERT' and lastname = 'BRADSHAW' )
insert into bss_memberidcards (id, memberid, expires) values ('31469008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'TERRI' and lastname = 'BRENNAN' )
insert into bss_memberidcards (id, memberid, expires) values ('62098004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'SARAH' and lastname = 'BRICE' )
insert into bss_memberidcards (id, memberid, expires) values ('62060004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ALEX' and lastname = 'BRINK' )
insert into bss_memberidcards (id, memberid, expires) values ('62381004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'KATIE' and lastname = 'BROWER' )
insert into bss_memberidcards (id, memberid, expires) values ('62061004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ALEX' and lastname = 'BROWN' )
insert into bss_memberidcards (id, memberid, expires) values ('7503012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'HENRY' and lastname = 'BROWN' )
insert into bss_memberidcards (id, memberid, expires) values ('7239012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'LEAH' and lastname = 'BRUSH' )
insert into bss_memberidcards (id, memberid, expires) values ('7435012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'LISA' and lastname = 'BURKLUND' )
insert into bss_memberidcards (id, memberid, expires) values ('7436012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ROB' and lastname = 'BURNELL' )
insert into bss_memberidcards (id, memberid, expires) values ('33393008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'SOPHIA' and lastname = 'BURNELL' )
insert into bss_memberidcards (id, memberid, expires) values ('62845004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'PATRICK' and lastname = 'BURNS' )
insert into bss_memberidcards (id, memberid, expires) values ('62349004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CHARLIE' and lastname = 'BUXTON' )
insert into bss_memberidcards (id, memberid, expires) values ('7498012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GREG' and lastname = 'CARLSON' )
insert into bss_memberidcards (id, memberid, expires) values ('62380004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CHRISTOPE' and lastname = 'CARNESE' )
insert into bss_memberidcards (id, memberid, expires) values ('34244008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CHRISTOPE' and lastname = 'CARNESE' )
insert into bss_memberidcards (id, memberid, expires) values ('62379004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'TYLER' and lastname = 'CARNESE' )
insert into bss_memberidcards (id, memberid, expires) values ('62378004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MARYA' and lastname = 'CASARTELLO' )
insert into bss_memberidcards (id, memberid, expires) values ('62062004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'NIAMH' and lastname = 'CHAMPINY' )
insert into bss_memberidcards (id, memberid, expires) values ('62099004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ADAM' and lastname = 'CHARBONNEAU' )
insert into bss_memberidcards (id, memberid, expires) values ('33846008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ADAM' and lastname = 'CHARBONNEAU' )
insert into bss_memberidcards (id, memberid, expires) values ('62377004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'COLE' and lastname = 'CHRISTINA' )
insert into bss_memberidcards (id, memberid, expires) values ('62555004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MELANIE' and lastname = 'CIENCIWA' )
insert into bss_memberidcards (id, memberid, expires) values ('62843004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JAMES' and lastname = 'CLARK' )
insert into bss_memberidcards (id, memberid, expires) values ('31686008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'WILLIAM' and lastname = 'CLARK' )
insert into bss_memberidcards (id, memberid, expires) values ('62101004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MARK' and lastname = 'CLARKE' )
insert into bss_memberidcards (id, memberid, expires) values ('62376004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'KEVIN' and lastname = 'CLENDENNIN' )
insert into bss_memberidcards (id, memberid, expires) values ('62102004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MORGAN' and lastname = 'CLENDENNIN' )
insert into bss_memberidcards (id, memberid, expires) values ('62065004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'FRANCOIS' and lastname = 'COEYTAUX' )
insert into bss_memberidcards (id, memberid, expires) values ('62103004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'AMES' and lastname = 'COLT' )
insert into bss_memberidcards (id, memberid, expires) values ('62375004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'AMES' and lastname = 'COLT' )
insert into bss_memberidcards (id, memberid, expires) values ('62454004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'NIKOLA' and lastname = 'COOPER-FATEYER' )
insert into bss_memberidcards (id, memberid, expires) values ('33394008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'KATHRYN' and lastname = 'CORBETT' )
insert into bss_memberidcards (id, memberid, expires) values ('34269008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'HUNTER' and lastname = 'CORMIER' )
insert into bss_memberidcards (id, memberid, expires) values ('62592004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'EMILY' and lastname = 'COUGHLIN' )
insert into bss_memberidcards (id, memberid, expires) values ('62104004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GARY' and lastname = 'COYNE' )
insert into bss_memberidcards (id, memberid, expires) values ('62394004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'SARA' and lastname = 'CRISAFI' )
insert into bss_memberidcards (id, memberid, expires) values ('62374004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'LANE' and lastname = 'CUNEO' )
insert into bss_memberidcards (id, memberid, expires) values ('33972008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JACK' and lastname = 'CURLETTI' )
insert into bss_memberidcards (id, memberid, expires) values ('61915004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'WILL' and lastname = 'CURLETTI' )
insert into bss_memberidcards (id, memberid, expires) values ('62063004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'TOM' and lastname = 'CURTIN' )
insert into bss_memberidcards (id, memberid, expires) values ('33395008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'STEFANIE' and lastname = 'D''ANGELO' )
insert into bss_memberidcards (id, memberid, expires) values ('62105004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'STEFANIE' and lastname = 'DANGELO' )
insert into bss_memberidcards (id, memberid, expires) values ('62110004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'FOREST' and lastname = 'DAVIS HOLLANDER' )
insert into bss_memberidcards (id, memberid, expires) values ('33024008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'SAM' and lastname = 'DENARD' )
insert into bss_memberidcards (id, memberid, expires) values ('31484008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ALAN' and lastname = 'DEVERRY' )
insert into bss_memberidcards (id, memberid, expires) values ('62373004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'RHAE' and lastname = 'DEVERRY' )
insert into bss_memberidcards (id, memberid, expires) values ('62372004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CHRIS' and lastname = 'DINAN' )
insert into bss_memberidcards (id, memberid, expires) values ('62371004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JAKE' and lastname = 'DITMAR' )
insert into bss_memberidcards (id, memberid, expires) values ('62846004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MATTHEW' and lastname = 'DONENFELD' )
insert into bss_memberidcards (id, memberid, expires) values ('33622008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'BRENDAN' and lastname = 'DORSEY' )
insert into bss_memberidcards (id, memberid, expires) values ('7242012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MEAGAN' and lastname = 'DORSEY' )
insert into bss_memberidcards (id, memberid, expires) values ('7246012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MATTHEW' and lastname = 'DOWD' )
insert into bss_memberidcards (id, memberid, expires) values ('32085008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'WILL' and lastname = 'DUBOCQ' )
insert into bss_memberidcards (id, memberid, expires) values ('62340004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'EVAN' and lastname = 'DUZAN' )
insert into bss_memberidcards (id, memberid, expires) values ('62607004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'BEGONIA' and lastname = 'EL KOURY' )
insert into bss_memberidcards (id, memberid, expires) values ('62345004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JAIME' and lastname = 'EL KOURY' )
insert into bss_memberidcards (id, memberid, expires) values ('33625008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JORGE' and lastname = 'EL KOURY' )
insert into bss_memberidcards (id, memberid, expires) values ('33624008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'LEILA' and lastname = 'ENGLISH' )
insert into bss_memberidcards (id, memberid, expires) values ('33628008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'HERB' and lastname = 'ESCHBACH' )
insert into bss_memberidcards (id, memberid, expires) values ('62473004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DENNY' and lastname = 'FAHEY' )
insert into bss_memberidcards (id, memberid, expires) values ('62453004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'RYAN' and lastname = 'FAHEY' )
insert into bss_memberidcards (id, memberid, expires) values ('62107004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'BENJAMIN' and lastname = 'FASCIANO' )
insert into bss_memberidcards (id, memberid, expires) values ('61365004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'BRENDAN' and lastname = 'FETZER' )
insert into bss_memberidcards (id, memberid, expires) values ('62106004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ZACHARY H' and lastname = 'FIFE' )
insert into bss_memberidcards (id, memberid, expires) values ('62064004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GREG' and lastname = 'FISKE' )
insert into bss_memberidcards (id, memberid, expires) values ('62370004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'EMMA' and lastname = 'FOLEY' )
insert into bss_memberidcards (id, memberid, expires) values ('7401012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'TOM' and lastname = 'FOOTE' )
insert into bss_memberidcards (id, memberid, expires) values ('62452004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JOHNNY' and lastname = 'FREE' )
insert into bss_memberidcards (id, memberid, expires) values ('62066004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MAGGIE' and lastname = 'FREE' )
insert into bss_memberidcards (id, memberid, expires) values ('62108004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CHARLIE' and lastname = 'FRIEDBERG' )
insert into bss_memberidcards (id, memberid, expires) values ('62067004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GAELEN' and lastname = 'FRINK' )
insert into bss_memberidcards (id, memberid, expires) values ('62109004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'HANNAH' and lastname = 'GARVEY' )
insert into bss_memberidcards (id, memberid, expires) values ('62844004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MATT' and lastname = 'GILLETTE' )
insert into bss_memberidcards (id, memberid, expires) values ('62111004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MELINDA' and lastname = 'GILLETTE' )
insert into bss_memberidcards (id, memberid, expires) values ('62369004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ERIC' and lastname = 'GIULIANO' )
insert into bss_memberidcards (id, memberid, expires) values ('31452008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ETHAN' and lastname = 'GOROFF' )
insert into bss_memberidcards (id, memberid, expires) values ('62068004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CAROLINE' and lastname = 'GRANT' )
insert into bss_memberidcards (id, memberid, expires) values ('62987004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'NICK' and lastname = 'GRAY' )
insert into bss_memberidcards (id, memberid, expires) values ('62341004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MICHAEL' and lastname = 'GREENBAUM' )
insert into bss_memberidcards (id, memberid, expires) values ('34291008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JULIA' and lastname = 'GROEBER' )
insert into bss_memberidcards (id, memberid, expires) values ('7150012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'REBECCA' and lastname = 'GROSSMA' )
insert into bss_memberidcards (id, memberid, expires) values ('62610004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'SARA' and lastname = 'GROVES' )
insert into bss_memberidcards (id, memberid, expires) values ('63291004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CHRISTOFER' and lastname = 'GSCHWIND' )
insert into bss_memberidcards (id, memberid, expires) values ('62368004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MARK' and lastname = 'GSCHWIND' )
insert into bss_memberidcards (id, memberid, expires) values ('62367004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JOHN' and lastname = 'GULA' )
insert into bss_memberidcards (id, memberid, expires) values ('62393004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CLAIRE' and lastname = 'GULICK' )
insert into bss_memberidcards (id, memberid, expires) values ('62366004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DONN' and lastname = 'GULICK' )
insert into bss_memberidcards (id, memberid, expires) values ('62365004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'PETER' and lastname = 'HABICHT' )
insert into bss_memberidcards (id, memberid, expires) values ('62364004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JIM' and lastname = 'HAGEN, SR.' )
insert into bss_memberidcards (id, memberid, expires) values ('62069004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JAY' and lastname = 'HALL' )
insert into bss_memberidcards (id, memberid, expires) values ('7151012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'TYLER' and lastname = 'HARRINGTON' )
insert into bss_memberidcards (id, memberid, expires) values ('33618008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JIM' and lastname = 'HARRISON' )
insert into bss_memberidcards (id, memberid, expires) values ('33412008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'BENJAMAN' and lastname = 'HIGA' )
insert into bss_memberidcards (id, memberid, expires) values ('33958008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'RAY' and lastname = 'HINMAN' )
insert into bss_memberidcards (id, memberid, expires) values ('62112004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'RAY' and lastname = 'HINMAN' )
insert into bss_memberidcards (id, memberid, expires) values ('62839004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'AUGUST' and lastname = 'HOCHMAN' )
insert into bss_memberidcards (id, memberid, expires) values ('61879004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ISABEL' and lastname = 'HOCHMAN' )
insert into bss_memberidcards (id, memberid, expires) values ('61878004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ISABEL' and lastname = 'HOCHMAN' )
insert into bss_memberidcards (id, memberid, expires) values ('33396008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JACOB' and lastname = 'HONIG' )
insert into bss_memberidcards (id, memberid, expires) values ('34242008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JEFFREY' and lastname = 'HOROWITZ' )
insert into bss_memberidcards (id, memberid, expires) values ('62113004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MARC' and lastname = 'HOROWITZ' )
insert into bss_memberidcards (id, memberid, expires) values ('62363004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ROGER' and lastname = 'HULL' )
insert into bss_memberidcards (id, memberid, expires) values ('34647008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'KEIRSTEN' and lastname = 'HUTTIG WILLIAMS' )
insert into bss_memberidcards (id, memberid, expires) values ('62606004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'SUSAN' and lastname = 'HYDE' )
insert into bss_memberidcards (id, memberid, expires) values ('33899008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MARK' and lastname = 'IANNONE' )
insert into bss_memberidcards (id, memberid, expires) values ('61282004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GABE' and lastname = 'IBANEZ' )
insert into bss_memberidcards (id, memberid, expires) values ('62362004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'OLIVIA' and lastname = 'JAFFE' )
insert into bss_memberidcards (id, memberid, expires) values ('62501004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'EMILY' and lastname = 'JENKINS' )
insert into bss_memberidcards (id, memberid, expires) values ('62342004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JOHN' and lastname = 'JEPSON' )
insert into bss_memberidcards (id, memberid, expires) values ('62457004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JOHN' and lastname = 'JEPSON' )


set @memberid = (select memberid from bss_Member where firstname = 'JOHN' and lastname = 'JEPSON' )
insert into bss_memberidcards (id, memberid, expires) values ('62458004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JASMIN' and lastname = 'JOHANNSDOTTIR' )
insert into bss_memberidcards (id, memberid, expires) values ('33816008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'KATE' and lastname = 'JOHNSON' )
insert into bss_memberidcards (id, memberid, expires) values ('62114004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'STEPHEN' and lastname = 'KALPIN' )
insert into bss_memberidcards (id, memberid, expires) values ('33397008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'STEVE' and lastname = 'KALPIN' )
insert into bss_memberidcards (id, memberid, expires) values ('7446012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'WILLIAM' and lastname = 'KANE' )
insert into bss_memberidcards (id, memberid, expires) values ('61279004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GARY' and lastname = 'KAPCHINSKE' )
insert into bss_memberidcards (id, memberid, expires) values ('62361004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CHRISTOPHER' and lastname = 'KEEGAN' )
insert into bss_memberidcards (id, memberid, expires) values ('34399008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'KATHLEEN' and lastname = 'KEEGAN' )
insert into bss_memberidcards (id, memberid, expires) values ('62070004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'TOBY' and lastname = 'KEENAN' )
insert into bss_memberidcards (id, memberid, expires) values ('7497012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DAVE' and lastname = 'KELLIHER' )
insert into bss_memberidcards (id, memberid, expires) values ('62395004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GREGG' and lastname = 'KIMBALL' )
insert into bss_memberidcards (id, memberid, expires) values ('62071004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ALAN' and lastname = 'KING' )
insert into bss_memberidcards (id, memberid, expires) values ('62115004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ALAN' and lastname = 'KING' )
insert into bss_memberidcards (id, memberid, expires) values ('33844008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ALAN' and lastname = 'KING' )


set @memberid = (select memberid from bss_Member where firstname = 'TYLER' and lastname = 'KING' )
insert into bss_memberidcards (id, memberid, expires) values ('62116004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'WILLIAM' and lastname = 'KING' )
insert into bss_memberidcards (id, memberid, expires) values ('62117004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MARTHA' and lastname = 'KLEIN' )
insert into bss_memberidcards (id, memberid, expires) values ('62118004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MARTHA' and lastname = 'KLEIN' )
insert into bss_memberidcards (id, memberid, expires) values ('34252008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'EMMA' and lastname = 'KLIMKOSKY' )
insert into bss_memberidcards (id, memberid, expires) values ('62072004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MATT' and lastname = 'KLIMKOSKY' )
insert into bss_memberidcards (id, memberid, expires) values ('62119004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GREG' and lastname = 'KNIGHT' )
insert into bss_memberidcards (id, memberid, expires) values ('62360004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'NIKKI' and lastname = 'KNIGHT' )
insert into bss_memberidcards (id, memberid, expires) values ('62073004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DAVID' and lastname = 'KOEHLER' )
insert into bss_memberidcards (id, memberid, expires) values ('61281004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GILLIAN' and lastname = 'KOTLEN' )
insert into bss_memberidcards (id, memberid, expires) values ('7357012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'KK' and lastname = 'KOZIK' )
insert into bss_memberidcards (id, memberid, expires) values ('34648008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MAGGIE' and lastname = 'KRATOVIL' )
insert into bss_memberidcards (id, memberid, expires) values ('62517004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JAMES' and lastname = 'KUHNLY' )
insert into bss_memberidcards (id, memberid, expires) values ('62346004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ANTHONY' and lastname = 'LABRASCA' )
insert into bss_memberidcards (id, memberid, expires) values ('33363008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JOEY' and lastname = 'LABRASCA' )
insert into bss_memberidcards (id, memberid, expires) values ('62359004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MEGAN' and lastname = 'LACOMBE' )
insert into bss_memberidcards (id, memberid, expires) values ('63091004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MEGAN' and lastname = 'LACOMBE' )
insert into bss_memberidcards (id, memberid, expires) values ('33364008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JOHN' and lastname = 'LAGATTUTA' )
insert into bss_memberidcards (id, memberid, expires) values ('33365008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'KIMBERLY' and lastname = 'LAMARCHE' )
insert into bss_memberidcards (id, memberid, expires) values ('62396004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GARY' and lastname = 'LARESE' )
insert into bss_memberidcards (id, memberid, expires) values ('33366008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'SCOTT' and lastname = 'LAROCHELLE' )
insert into bss_memberidcards (id, memberid, expires) values ('62609004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ELIZABETH' and lastname = 'LAVALLEE' )
insert into bss_memberidcards (id, memberid, expires) values ('62358004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'KATHRYN' and lastname = 'LAVALLEE' )
insert into bss_memberidcards (id, memberid, expires) values ('62384004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'VICTORIA' and lastname = 'LAVALLEE' )
insert into bss_memberidcards (id, memberid, expires) values ('62385004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CLAIRE' and lastname = 'LAVERS' )
insert into bss_memberidcards (id, memberid, expires) values ('7395012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'LINDSAY' and lastname = 'LEBRECHT' )
insert into bss_memberidcards (id, memberid, expires) values ('33367008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'KAITLIN' and lastname = 'LECCE' )
insert into bss_memberidcards (id, memberid, expires) values ('61881004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'KRISTEN' and lastname = 'LECCE' )
insert into bss_memberidcards (id, memberid, expires) values ('62397004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JOHN' and lastname = 'LEE' )
insert into bss_memberidcards (id, memberid, expires) values ('34095008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JOHN' and lastname = 'LEE' )
insert into bss_memberidcards (id, memberid, expires) values ('7438012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'BRIAN' and lastname = 'LEHNING' )
insert into bss_memberidcards (id, memberid, expires) values ('62074004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'VICTORIA' and lastname = 'LEHNING' )
insert into bss_memberidcards (id, memberid, expires) values ('33368008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'RYAN' and lastname = 'LENNARD' )
insert into bss_memberidcards (id, memberid, expires) values ('33627008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MARK' and lastname = 'LEVI' )
insert into bss_memberidcards (id, memberid, expires) values ('33370008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JARED' and lastname = 'LEWIS' )
insert into bss_memberidcards (id, memberid, expires) values ('62386004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JARED' and lastname = 'LEWIS' )
insert into bss_memberidcards (id, memberid, expires) values ('62170004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JARED' and lastname = 'LEWIS' )
insert into bss_memberidcards (id, memberid, expires) values ('33772008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'AL' and lastname = 'LIEB' )
insert into bss_memberidcards (id, memberid, expires) values ('30419008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'BEN' and lastname = 'LIPPMAN' )
insert into bss_memberidcards (id, memberid, expires) values ('61889004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ERIC' and lastname = 'LIPPMAN' )
insert into bss_memberidcards (id, memberid, expires) values ('33398008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ELLA' and lastname = 'LONG' )
insert into bss_memberidcards (id, memberid, expires) values ('33076008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DYLAN' and lastname = 'LUBECK' )
insert into bss_memberidcards (id, memberid, expires) values ('7393012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'HANNAH' and lastname = 'LUBECK' )
insert into bss_memberidcards (id, memberid, expires) values ('63024004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ROLL' and lastname = 'LUSSIER' )
insert into bss_memberidcards (id, memberid, expires) values ('33373008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'VERN' and lastname = 'LUSSIER' )
insert into bss_memberidcards (id, memberid, expires) values ('33267008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'LOUISE' and lastname = 'LYNCH' )
insert into bss_memberidcards (id, memberid, expires) values ('62456004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'WILLIAM' and lastname = 'LYON' )
insert into bss_memberidcards (id, memberid, expires) values ('34712008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ELIZA' and lastname = 'MAGGIO' )
insert into bss_memberidcards (id, memberid, expires) values ('62075004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'SHAWN' and lastname = 'MAGILL' )
insert into bss_memberidcards (id, memberid, expires) values ('62076004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'TINA' and lastname = 'MAGILL' )
insert into bss_memberidcards (id, memberid, expires) values ('61283004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CATE' and lastname = 'MAHONEY' )
insert into bss_memberidcards (id, memberid, expires) values ('62344004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JACOB' and lastname = 'MAKUC' )
insert into bss_memberidcards (id, memberid, expires) values ('62077004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'BROOKE' and lastname = 'MARS' )
insert into bss_memberidcards (id, memberid, expires) values ('33374008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CLAUDIA' and lastname = 'MARTIN' )
insert into bss_memberidcards (id, memberid, expires) values ('62485004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'KEVIN' and lastname = 'MARZOTTO' )
insert into bss_memberidcards (id, memberid, expires) values ('62851004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MASHO' and lastname = 'MCALISTER' )
insert into bss_memberidcards (id, memberid, expires) values ('62078004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'WEYESSA' and lastname = 'MCALISTER' )
insert into bss_memberidcards (id, memberid, expires) values ('34247008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CASEY' and lastname = 'MCCABE' )
insert into bss_memberidcards (id, memberid, expires) values ('33724008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ED' and lastname = 'MCCANN' )
insert into bss_memberidcards (id, memberid, expires) values ('33375008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JOHN' and lastname = 'MCCANN' )
insert into bss_memberidcards (id, memberid, expires) values ('33376008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'LYNN' and lastname = 'MCCANN' )
insert into bss_memberidcards (id, memberid, expires) values ('33377008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'PETER' and lastname = 'MCCANN' )
insert into bss_memberidcards (id, memberid, expires) values ('33399008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CEARA' and lastname = 'MCDONNELL' )
insert into bss_memberidcards (id, memberid, expires) values ('62079004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'TOM' and lastname = 'MCDONNELL' )
insert into bss_memberidcards (id, memberid, expires) values ('31409008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'IAN' and lastname = 'MCHUGH' )
insert into bss_memberidcards (id, memberid, expires) values ('33626008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'IAN' and lastname = 'MCHUGH' )
insert into bss_memberidcards (id, memberid, expires) values ('33452008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ANGUS' and lastname = 'MCLAREN' )
insert into bss_memberidcards (id, memberid, expires) values ('63002004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ANGUS' and lastname = 'MCLAREN' )
insert into bss_memberidcards (id, memberid, expires) values ('33378008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ANGUS' and lastname = 'MCLAREN' )
insert into bss_memberidcards (id, memberid, expires) values ('63003004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'SINEAD' and lastname = 'MCNABOE' )
insert into bss_memberidcards (id, memberid, expires) values ('62462004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ANNIE' and lastname = 'MCVEIGH' )
insert into bss_memberidcards (id, memberid, expires) values ('61286004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'COLIN' and lastname = 'MCVEIGH' )
insert into bss_memberidcards (id, memberid, expires) values ('61287004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'BRAD' and lastname = 'MERENSTEIN' )
insert into bss_memberidcards (id, memberid, expires) values ('33379008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'BRUCE' and lastname = 'MERKIS' )
insert into bss_memberidcards (id, memberid, expires) values ('62398004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MARGARETH' and lastname = 'MESCHTER' )
insert into bss_memberidcards (id, memberid, expires) values ('62387004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DANIEL' and lastname = 'MILLER' )
insert into bss_memberidcards (id, memberid, expires) values ('62080004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'BARBARA' and lastname = 'MINKOFF' )
insert into bss_memberidcards (id, memberid, expires) values ('32948008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ELIZA J.' and lastname = 'MITCHELL' )
insert into bss_memberidcards (id, memberid, expires) values ('62620004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ISABEL S.' and lastname = 'MITCHELL' )
insert into bss_memberidcards (id, memberid, expires) values ('62120004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'SAMANTHA' and lastname = 'MITCHELL' )
insert into bss_memberidcards (id, memberid, expires) values ('62121004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GARY' and lastname = 'MORRIS' )
insert into bss_memberidcards (id, memberid, expires) values ('61997004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GEORGE' and lastname = 'MOSLER' )
insert into bss_memberidcards (id, memberid, expires) values ('62460004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GEORGE' and lastname = 'MOSLER' )
insert into bss_memberidcards (id, memberid, expires) values ('62459004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GEORGE' and lastname = 'MOSLER' )
insert into bss_memberidcards (id, memberid, expires) values ('31453008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'THOMAS' and lastname = 'MOSLER' )
insert into bss_memberidcards (id, memberid, expires) values ('62122004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ELIE' and lastname = 'MOUCHANTAT' )
insert into bss_memberidcards (id, memberid, expires) values ('7394012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MICHAEL' and lastname = 'MOUCHANTAT' )
insert into bss_memberidcards (id, memberid, expires) values ('7496012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'NICK' and lastname = 'MURNER' )
insert into bss_memberidcards (id, memberid, expires) values ('33885008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ROBERT' and lastname = 'MURNER' )
insert into bss_memberidcards (id, memberid, expires) values ('62123004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JESSICA' and lastname = 'MUSIAK' )
insert into bss_memberidcards (id, memberid, expires) values ('7356012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'HANNAH' and lastname = 'MUSKA' )
insert into bss_memberidcards (id, memberid, expires) values ('34537008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'HANNAH' and lastname = 'MUSKA' )
insert into bss_memberidcards (id, memberid, expires) values ('62124004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JOSHUA' and lastname = 'MUSKA' )
insert into bss_memberidcards (id, memberid, expires) values ('62954004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JOSHUA' and lastname = 'MUSKA' )
insert into bss_memberidcards (id, memberid, expires) values ('62125004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JAKE' and lastname = 'NADLER' )
insert into bss_memberidcards (id, memberid, expires) values ('31476008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JON' and lastname = 'NELSON' )
insert into bss_memberidcards (id, memberid, expires) values ('62126004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JOSHUA' and lastname = 'NELSON' )
insert into bss_memberidcards (id, memberid, expires) values ('62127004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MORIAH' and lastname = 'NELSON' )
insert into bss_memberidcards (id, memberid, expires) values ('62464004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'EVAN' and lastname = 'NEWMAN' )
insert into bss_memberidcards (id, memberid, expires) values ('7158012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JEREMY' and lastname = 'NOEL' )
insert into bss_memberidcards (id, memberid, expires) values ('62081004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'NATHAN' and lastname = 'NOEL' )
insert into bss_memberidcards (id, memberid, expires) values ('62082004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'SAVANNA' and lastname = 'NOLAU' )
insert into bss_memberidcards (id, memberid, expires) values ('33617008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ERIK' and lastname = 'NORDMARK' )
insert into bss_memberidcards (id, memberid, expires) values ('61364004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'LIANE' and lastname = 'NOURI' )
insert into bss_memberidcards (id, memberid, expires) values ('62128004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MICHAEL' and lastname = 'NOURI' )
insert into bss_memberidcards (id, memberid, expires) values ('33871008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'KARL' and lastname = 'OPPENHEIMER' )
insert into bss_memberidcards (id, memberid, expires) values ('62399004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'WARREN' and lastname = 'PALMER' )
insert into bss_memberidcards (id, memberid, expires) values ('62601004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MARY' and lastname = 'PANAGROSSO' )
insert into bss_memberidcards (id, memberid, expires) values ('62129004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'SIERRA' and lastname = 'PARDUS' )
insert into bss_memberidcards (id, memberid, expires) values ('62083004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'YOONHO' and lastname = 'PARK' )
insert into bss_memberidcards (id, memberid, expires) values ('62131004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MATTHEW' and lastname = 'PARKES' )
insert into bss_memberidcards (id, memberid, expires) values ('62084004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DAN' and lastname = 'PATEL' )
insert into bss_memberidcards (id, memberid, expires) values ('33843008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ERIC' and lastname = 'PATTISON' )
insert into bss_memberidcards (id, memberid, expires) values ('61366004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'HAROLD' and lastname = 'PATZELT' )
insert into bss_memberidcards (id, memberid, expires) values ('62132004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'NICHOLAS' and lastname = 'PAUL' )
insert into bss_memberidcards (id, memberid, expires) values ('62133004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'THOMAS' and lastname = 'PELLATT' )
insert into bss_memberidcards (id, memberid, expires) values ('32078008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'TONY' and lastname = 'PERCIVALLE' )
insert into bss_memberidcards (id, memberid, expires) values ('62137004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ELIZABETH' and lastname = 'PERKINS' )
insert into bss_memberidcards (id, memberid, expires) values ('62140004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DAVE' and lastname = 'PESCHEL' )
insert into bss_memberidcards (id, memberid, expires) values ('62141004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ALEXA' and lastname = 'PFEIFFER' )
insert into bss_memberidcards (id, memberid, expires) values ('34250008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ALEXA' and lastname = 'PFEIFFER' )
insert into bss_memberidcards (id, memberid, expires) values ('62388004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MERYL' and lastname = 'PHAIR' )
insert into bss_memberidcards (id, memberid, expires) values ('62086004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'KARLI' and lastname = 'PIANOWSKI' )
insert into bss_memberidcards (id, memberid, expires) values ('33957008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'NATHAN' and lastname = 'PIANTEK' )
insert into bss_memberidcards (id, memberid, expires) values ('61297004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'HEATHER' and lastname = 'PINKHAM' )
insert into bss_memberidcards (id, memberid, expires) values ('62142004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GEORGENE' and lastname = 'POLIAK' )
insert into bss_memberidcards (id, memberid, expires) values ('61632004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GEORGENE' and lastname = 'POLIAK' )
insert into bss_memberidcards (id, memberid, expires) values ('62461004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ANTHONY' and lastname = 'POLYAK' )
insert into bss_memberidcards (id, memberid, expires) values ('62527004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'KATTY' and lastname = 'POLYAK' )
insert into bss_memberidcards (id, memberid, expires) values ('7223012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DANIEL' and lastname = 'POMERANTZ' )
insert into bss_memberidcards (id, memberid, expires) values ('33966008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'LUCAS' and lastname = 'POTTER' )
insert into bss_memberidcards (id, memberid, expires) values ('7247012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JUSTIN' and lastname = 'PRATT' )
insert into bss_memberidcards (id, memberid, expires) values ('62143004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'LOIS' and lastname = 'QUARTARARO' )
insert into bss_memberidcards (id, memberid, expires) values ('62144004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DAVID' and lastname = 'QUISENBERRY' )
insert into bss_memberidcards (id, memberid, expires) values ('62145004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GRAHAM' and lastname = 'QUISENBERRY' )
insert into bss_memberidcards (id, memberid, expires) values ('62146004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JENNIFER' and lastname = 'QUISENBERRY' )
insert into bss_memberidcards (id, memberid, expires) values ('62147004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'PAUL' and lastname = 'REED' )
insert into bss_memberidcards (id, memberid, expires) values ('33960008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'PAUL' and lastname = 'REED' )
insert into bss_memberidcards (id, memberid, expires) values ('62148004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ALISON' and lastname = 'REGGIANNINI' )
insert into bss_memberidcards (id, memberid, expires) values ('31473008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'COURTNEY' and lastname = 'REGGIANNINI' )
insert into bss_memberidcards (id, memberid, expires) values ('31474008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JAMES' and lastname = 'RICE' )
insert into bss_memberidcards (id, memberid, expires) values ('62389004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JAMIE' and lastname = 'RICE' )
insert into bss_memberidcards (id, memberid, expires) values ('7396012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ALEXANDRA' and lastname = 'RIX' )
insert into bss_memberidcards (id, memberid, expires) values ('62149004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'RON' and lastname = 'RIX' )
insert into bss_memberidcards (id, memberid, expires) values ('62150004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GAIL' and lastname = 'ROGER' )
insert into bss_memberidcards (id, memberid, expires) values ('62151004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'LEONCE' and lastname = 'ROGER' )
insert into bss_memberidcards (id, memberid, expires) values ('62152004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JACOB' and lastname = 'ROSEN' )
insert into bss_memberidcards (id, memberid, expires) values ('31475008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GILLIAN' and lastname = 'ROSH' )
insert into bss_memberidcards (id, memberid, expires) values ('62153004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JULIANNE' and lastname = 'ROSSI' )
insert into bss_memberidcards (id, memberid, expires) values ('62154004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JENNA' and lastname = 'ROTHERMEL' )
insert into bss_memberidcards (id, memberid, expires) values ('62983004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'NATHANIEL' and lastname = 'ROY' )
insert into bss_memberidcards (id, memberid, expires) values ('33882008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'RON' and lastname = 'RYASON' )
insert into bss_memberidcards (id, memberid, expires) values ('62155004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'NICHOLAS' and lastname = 'SAGARIN' )
insert into bss_memberidcards (id, memberid, expires) values ('7500012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JENNY' and lastname = 'SAGE' )
insert into bss_memberidcards (id, memberid, expires) values ('62204004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JIM' and lastname = 'SALIBA' )
insert into bss_memberidcards (id, memberid, expires) values ('61387004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JIMMY' and lastname = 'SALINA' )
insert into bss_memberidcards (id, memberid, expires) values ('33866008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DANIEL' and lastname = 'SANTOS' )
insert into bss_memberidcards (id, memberid, expires) values ('62087004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'WALTER' and lastname = 'SARAMAK' )
insert into bss_memberidcards (id, memberid, expires) values ('62156004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ASPEN' and lastname = 'SAWYER' )
insert into bss_memberidcards (id, memberid, expires) values ('61285004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'PETER' and lastname = 'SCARPELLI' )
insert into bss_memberidcards (id, memberid, expires) values ('62400004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'HELGA' and lastname = 'SCHEIDLE' )
insert into bss_memberidcards (id, memberid, expires) values ('62157004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'STUART' and lastname = 'SCHMALL' )
insert into bss_memberidcards (id, memberid, expires) values ('62158004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CAMERON' and lastname = 'SCOTT' )
insert into bss_memberidcards (id, memberid, expires) values ('62088004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ROBIN' and lastname = 'SEARING' )
insert into bss_memberidcards (id, memberid, expires) values ('62159004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'SAM' and lastname = 'SECKLER' )
insert into bss_memberidcards (id, memberid, expires) values ('62558004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MURU' and lastname = 'SENTHILVELAN' )
insert into bss_memberidcards (id, memberid, expires) values ('62160004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JANE' and lastname = 'SHERWIN' )
insert into bss_memberidcards (id, memberid, expires) values ('32968008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JANE' and lastname = 'SHERWIN' )
insert into bss_memberidcards (id, memberid, expires) values ('62455004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JACOB' and lastname = 'SHIVERS' )
insert into bss_memberidcards (id, memberid, expires) values ('62089004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DOUGLAS' and lastname = 'SHUFELT' )
insert into bss_memberidcards (id, memberid, expires) values ('62401004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DAVID' and lastname = 'SHULMAN' )
insert into bss_memberidcards (id, memberid, expires) values ('62161004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GRACE' and lastname = 'SILVA' )
insert into bss_memberidcards (id, memberid, expires) values ('7495012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'LIZ' and lastname = 'SMITH' )
insert into bss_memberidcards (id, memberid, expires) values ('34281008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CHARLENE' and lastname = 'SMOLKOWICZ' )
insert into bss_memberidcards (id, memberid, expires) values ('62162004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'GEOFFREY' and lastname = 'SOKOLSKY' )
insert into bss_memberidcards (id, memberid, expires) values ('33880008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JONATHAN' and lastname = 'SOKOLSKY' )
insert into bss_memberidcards (id, memberid, expires) values ('62863004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MATTHEW' and lastname = 'SPENCE' )
insert into bss_memberidcards (id, memberid, expires) values ('7437012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CAROLINE' and lastname = 'SPRAGUE' )
insert into bss_memberidcards (id, memberid, expires) values ('62090004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MICHAEL' and lastname = 'STARK' )
insert into bss_memberidcards (id, memberid, expires) values ('62163004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'SEAN' and lastname = 'STEPHEN' )
insert into bss_memberidcards (id, memberid, expires) values ('61482004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JONATHAN' and lastname = 'STILES' )
insert into bss_memberidcards (id, memberid, expires) values ('33869008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CHASE' and lastname = 'STRAWN' )
insert into bss_memberidcards (id, memberid, expires) values ('33872008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'OLIVIA' and lastname = 'SUK' )
insert into bss_memberidcards (id, memberid, expires) values ('33623008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JACK' and lastname = 'SULLIVAN' )
insert into bss_memberidcards (id, memberid, expires) values ('34699008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'EVAN' and lastname = 'SYLBERT' )
insert into bss_memberidcards (id, memberid, expires) values ('7397012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ANGIE' and lastname = 'TAYLOR' )
insert into bss_memberidcards (id, memberid, expires) values ('62390004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'STEVE' and lastname = 'TAYLOR' )
insert into bss_memberidcards (id, memberid, expires) values ('33392008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JACOB' and lastname = 'TEICH' )
insert into bss_memberidcards (id, memberid, expires) values ('62792004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'HELENA' and lastname = 'THATCHER' )
insert into bss_memberidcards (id, memberid, expires) values ('7501012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'LAURA' and lastname = 'THIBAULT' )
insert into bss_memberidcards (id, memberid, expires) values ('61296004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ZAC' and lastname = 'THOMAS' )
insert into bss_memberidcards (id, memberid, expires) values ('62171004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'TREVOR' and lastname = 'THOMPSON' )
insert into bss_memberidcards (id, memberid, expires) values ('62172004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CARTER' and lastname = 'THORNE-KAUNELIS' )
insert into bss_memberidcards (id, memberid, expires) values ('34298008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'KESTREL' and lastname = 'THORNE-KAUNELIS' )
insert into bss_memberidcards (id, memberid, expires) values ('7502012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'WINTER' and lastname = 'THORNE-KAUNELIS' )
insert into bss_memberidcards (id, memberid, expires) values ('62173004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'FRENCHY' and lastname = 'TRUITT' )
insert into bss_memberidcards (id, memberid, expires) values ('62608004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ROBERT' and lastname = 'TURTZ' )
insert into bss_memberidcards (id, memberid, expires) values ('62174004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'NOAH' and lastname = 'ULLMAN' )
insert into bss_memberidcards (id, memberid, expires) values ('33380008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DALE' and lastname = 'VANDERVOORT' )
insert into bss_memberidcards (id, memberid, expires) values ('33381008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DARCY' and lastname = 'VICTORY' )
insert into bss_memberidcards (id, memberid, expires) values ('33382008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'KAITLYN' and lastname = 'VICTORY' )
insert into bss_memberidcards (id, memberid, expires) values ('33383008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'STEVE' and lastname = 'VICTORY' )
insert into bss_memberidcards (id, memberid, expires) values ('33384008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DAMIAN' and lastname = 'VINCENT' )
insert into bss_memberidcards (id, memberid, expires) values ('62933004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'NICHOLAS' and lastname = 'VISSCHER' )
insert into bss_memberidcards (id, memberid, expires) values ('62091004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ERIKA' and lastname = 'WAINWRIGHT' )
insert into bss_memberidcards (id, memberid, expires) values ('62092004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CRAIG' and lastname = 'WARD' )
insert into bss_memberidcards (id, memberid, expires) values ('7400012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'BEN' and lastname = 'WEBB' )
insert into bss_memberidcards (id, memberid, expires) values ('62093004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MAX' and lastname = 'WEIDINGER' )
insert into bss_memberidcards (id, memberid, expires) values ('33900008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JACOB' and lastname = 'WEINER' )
insert into bss_memberidcards (id, memberid, expires) values ('62094004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'PAT' and lastname = 'WHITE' )
insert into bss_memberidcards (id, memberid, expires) values ('33385008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JESSICA' and lastname = 'WIKLE' )
insert into bss_memberidcards (id, memberid, expires) values ('33771008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'SAMUEL' and lastname = 'WILLIAMS' )
insert into bss_memberidcards (id, memberid, expires) values ('62836004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'ELLIOT' and lastname = 'WILSON' )
insert into bss_memberidcards (id, memberid, expires) values ('34105008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MAREN' and lastname = 'WILSON' )
insert into bss_memberidcards (id, memberid, expires) values ('62391004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'CAITLIN' and lastname = 'WOOD' )
insert into bss_memberidcards (id, memberid, expires) values ('33387008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'MOLLY' and lastname = 'WOOD' )
insert into bss_memberidcards (id, memberid, expires) values ('33388008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'PETER' and lastname = 'WOOD' )
insert into bss_memberidcards (id, memberid, expires) values ('33386008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'RILEY' and lastname = 'WOOD' )
insert into bss_memberidcards (id, memberid, expires) values ('33389008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'FAREN' and lastname = 'WORTHINGTON' )
insert into bss_memberidcards (id, memberid, expires) values ('62392004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'NANCI' and lastname = 'WORTHINGTON' )
insert into bss_memberidcards (id, memberid, expires) values ('61888004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JEFFREY' and lastname = 'WRIGHT' )
insert into bss_memberidcards (id, memberid, expires) values ('33390008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'DORIS' and lastname = 'YOUMELL' )
insert into bss_memberidcards (id, memberid, expires) values ('33391008000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'JOSH' and lastname = 'ZINBERG' )
insert into bss_memberidcards (id, memberid, expires) values ('62556004000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'RACHEL' and lastname = 'ZINBERG' )
insert into bss_memberidcards (id, memberid, expires) values ('7348012000', @memberid, '4-30-2015')


set @memberid = (select memberid from bss_Member where firstname = 'EDWARD' and lastname = 'ZONENBERG' )
insert into bss_memberidcards (id, memberid, expires) values ('31403008000', @memberid, '4-30-2015')


